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---

--
RyGuy


"Steve" wrote:

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?