View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean S
 
Posts: n/a
Default How to do a numercial sort?

Hi all,

I've got a column in a sheet that I'm trying to sort numerically but excel
will only sort it alphabetically, eg. 900 90 890 800 7 65...

I've tried formatting the cells as 'number' but this makes no difference.

The excel help says to convert text cells to number cells to click the cells
'marked with an error indicator'. None of the cells have an error indicator!

What am I missing?