| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SORTING TEXT AND NUMBERS
i am trying to sort a non sequential list of numbers mixed with numbers
marked with an asterisk in front, such as on a bank statement of checks: 1224 1222 *1223 1221 1227 *1225 1228 and so on. When I sort, all of the numbers with an asterisk are grouped together. I formatted them as text with the same result. Is there anything i can do? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
| Sorting numbers and text separately | Excel Discussion (Misc queries) | |||
| Sorting order - text and numbers | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Threaded Mode
