| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to Count Zip Code Digits With Leading Zero
If you have the cell formatted as Zip Code, why are you checking its length
at all? Wouldn't all your zip codes have to be 5 characters long with that format? Or are you putting something else besides zip codes in a cell formatted as Zip Code? If that is what you are doing, then what other entries can there be? -- Rick (MVP - Excel) "Daren" wrote in message ... Hello, I have a zip code as 06110 formatted as zip code. I used LEN on that zip code and it returns a 4 because it's not reading the leading zero. Is there a function that will return a value of 5 for a zip code with a leading zero and still be able to return a value of 5 for zip codes that have 5 digits? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Truncate leading digits of large number | Excel Discussion (Misc queries) | |||
| zero fill leading digits | Excel Discussion (Misc queries) | |||
| Validation rule - custom 5 digits w/ leading zeroes | Excel Worksheet Functions | |||
| Leading digits | Excel Discussion (Misc queries) | |||
| how do you display a zip code with a leading zero | Excel Discussion (Misc queries) | |||
Threaded Mode
