| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you sort zip codes with 0's being the lead number?
How do you sort zip codes where some of them start with 0? I have changed
the format to text, number, general with no luck. I would like to be able to do this without having to put a ' in front of the number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| A sort of lookup or match | Excel Worksheet Functions | |||
| Excel doesn't sort zip codes properly | Excel Discussion (Misc queries) | |||
| how do i format zip codes that lead with a "0" in excel for a wor. | Setting up and Configuration of Excel | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
Threaded Mode
