| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort text as numbers
I have the following list of text entries (that appear to be both numbers and
text, but the cells are all formatted as text) that I need to sort in numerical order from left to right. I can't find a sort option that let's me do this - can anyone help? Thanks! 3230 5109 6039 51282 1407D 3234H 4108A 4512H |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract numbers from cell with Text and Numbers | New Users to Excel | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Using numbers as numbers in a cell having text | Excel Discussion (Misc queries) | |||
| Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
| Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
Threaded Mode
