| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to Count Zip Code Digits With Leading Zero
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
