Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sortin Numbers as Text: How?
No mater what I do Excel in its infinite wisdom sorts numbers as numbers. I
want it to sort the numbers as text. I have not tried prefixing the entered numbers with an "'". The data comes from another application as text. In my version of Excel (Excell 2000 (9.0.3821 SR1), the options button ot the Data/Sort menue will not accept new custom sort orders. Is there a way to sort text numbers as text? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
Data Sortin Problem | Excel Discussion (Misc queries) | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
Sortin method advice please | Excel Worksheet Functions |