| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort by numbers of digits in cells
Hi,
I need to sort a large document by a certain column. That column consists of numbers that are six digits and five digits. I need to insert a leading zero in all those numbers that consist of only five digits. Some of those six digit numbers already correctly have the leading zero, so when I sort, it doesn't isolate the five digit ones. Any ideas on how I can do this? TIA, -- mab |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort cells with cell reference to get the same numbers? | Excel Discussion (Misc queries) | |||
| How do I sort the last 3 digits first and then the first 4 digit?. | Excel Worksheet Functions | |||
| Sort by last 2 digits | Excel Discussion (Misc queries) | |||
| sort numbers high to low, copy to new cells with associated data. | Excel Worksheet Functions | |||
| Sort by last 2 digits | Excel Worksheet Functions | |||
Threaded Mode
