Sorting Numerically
 

Pleas help. I have a spreadsheet that was e-mailed to me and it is not
sorting the data properly. I am trying to sort by decending order and
this is what happens:

828
827
824
8,903
8,581
-8
791
786
773
758
75
746
738
732
726
719
7,964

How can I get it to sort with 8,903 being the first value and -8 being
the last??

Sorting Numerically
 

Pl see response in your later post
(convert text numbers to real numbers)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ps.com...
Pleas help. I have a spreadsheet that was e-mailed to me and it is not
sorting the data properly. I am trying to sort by decending order and
this is what happens:

828
827
824
8,903
8,581
-8
791
786
773
758
75
746
738
732
726
719
7,964

How can I get it to sort with 8,903 being the first value and -8 being
the last??