| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get a leading zero (ZIP code) to show in a LEFT() calc?
I have a numeric field that is formatted to display as a ZIP code and a field
to its right that is supposed to show the first three digits of the ZIP code for 3-digit sorting. However, Excel strips the leading 0 off ZIP code numbers beginning with it before storing it, resulting in incorrect data in the field on the right, which displays the LEFT(...,3) function result. What's more, the actual ZIP codes print without the leading zeroes. How can I get the leading zeroes to print and be included in the 3-digit field? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to calc | Excel Discussion (Misc queries) | |||
| I'm looking for a formula to calc # of days left in a month | Excel Worksheet Functions | |||
| Leading zero in zip code won't print | Excel Discussion (Misc queries) | |||
| How do I retain leading zero zip code formatting when saving as a. | Excel Discussion (Misc queries) | |||
| how do you display a zip code with a leading zero | Excel Discussion (Misc queries) | |||
Threaded Mode
