| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting numbers with an irregular number of digits
I am working on a database and am importing customer numbers that
initially started with 1 digit and now include 5 digit numbers. When sorted, the numbers with fewer digits are mixed in with the larger digit numbers. Is there a way to add zeroes to the smaller numbers so they sort correctly? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| how to sort anything that looks like a number as a number | Excel Discussion (Misc queries) | |||
| maximum number size/significant digits | Excel Discussion (Misc queries) | |||
| Sorting Numbers w/Aplha Suffix | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Threaded Mode
