Excel Sort Doesn't Work
On Sat, 22 Aug 2009 11:29:36 -0700 (PDT), PeterOut
wrote:
0.044991
0.012016
0.027636
0.187865
0.01452
-0.104374
Works fine on mine.
Perhaps even though you changed the cell formatting to be proper, the
originally entered data is still text.
Cut and paste the list into notepad, and then copy and paste it back
into excel from there. That will strip any formatting, and paste only
numeric data into a numeric cell.
|