| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep zeros in front of other numbers (like a zip code)?
I'm doing a customer tally sheet which includes zip codes. Excel keeps
erasing the the first zero - 01085 for example will show up as 1085. Is there any way to keep that from happening? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep zeros in front of other numbers (like a zip code)?
If you are entering them use the format text first, or type ' and then the
number. I have a format under special that is specially for "zipcodes" but seeing as I am in Norway they are really postnummer. Maybe you have the same??? "RitoruIkko" wrote: I'm doing a customer tally sheet which includes zip codes. Excel keeps erasing the the first zero - 01085 for example will show up as 1085. Is there any way to keep that from happening? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep zeros in front of other numbers (like a zip code)?
http://support.microsoft.com/kb/81518/en-us
"RitoruIkko" wrote: I'm doing a customer tally sheet which includes zip codes. Excel keeps erasing the the first zero - 01085 for example will show up as 1085. Is there any way to keep that from happening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbers turning to Zero's | Excel Discussion (Misc queries) | |||
| Change case...help please | Excel Worksheet Functions | |||
| sort numbers leading zeros | Excel Discussion (Misc queries) | |||
| finding the no. of rows in a COL filled with numbers, zeros and bl | Excel Worksheet Functions | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Linear Mode
