| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to do a numercial sort?
Sean
Data previously formatted a text is difficult to convert back to numbers by simply changing the format. To do this en masse, enter a 1 in a spare cell and copy it. Highlight the stubborn cells and select editpaste special...values+multiply Now they will sort fine -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Sean S" wrote in message ... 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? |
| Reply |
| 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) | |||
Linear Mode
