| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Threaded Mode
