| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting problem
I am sorting a two columns of three digit numbers. In the second
column, 000 is sorting after 999. Anybody know what I'm doing wrong? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting problem
One possibility is that some of your entries may be text and some numbers?
Check with ISTEXT() and ISNUMBER(). Also, if you have two columns, are you sorting by both columns, and if so, in what priority order, and what are the corresponding entries in the other column if that is influencing the sorting? -- David Biddulph wrote in message ups.com... I am sorting a two columns of three digit numbers. In the second column, 000 is sorting after 999. Anybody know what I'm doing wrong? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting problem
It's text that's why. You can copy an empty cell, select the cells with the
000 and do editpaste special and select add, then use a custom format of 000 -- Regards, Peo Sjoblom wrote in message ups.com... I am sorting a two columns of three digit numbers. In the second column, 000 is sorting after 999. Anybody know what I'm doing wrong? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting problem, need some help | Excel Worksheet Functions | |||
| Sorting Problem | Excel Discussion (Misc queries) | |||
| Sorting problem | Excel Discussion (Misc queries) | |||
| Problem Sorting | New Users to Excel | |||
| Sorting problem | Excel Worksheet Functions | |||
Hybrid Mode
