Excel will not sort column

[Steve]

I have copied columns from one excel sheet to another and when i go to sort
my one column that i moved it will not sort. All other columns that were
there originally will sort but not the numbers that i moved. Any ideas?

 

[ryguy7272]

Whether the data is text or numbers, it should sort. Maybe, what you think
you are looking at is not actually what you are looking at. Try to find out
what kind of data you are working with:

=ISNUMBER(A1)
will show you whether the data is numeric or something else

=ISTEXT(A2)
will show you whether the data is text or something else

=TRIM(A3)
will delete any spaces in front of your data


Hope some of this helps.

Regards,
Ryan---

 

[Stephen]

Well, which did you do - copy the column, or move it? Was it a complete
column, or a range of cells? Did you insert it, or paste into an existing
column/range? If the latter, how were the cells formatted before pasting?
How are the cells formatted now? Do you have formulas in the cells, or
values? When you say "will not sort", what happens - nothing at all, or it
sorts in an unexpected order?