View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Capt. Cave Man Capt. Cave Man is offline
external usenet poster
 
Posts: 11
Default 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.