| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep a zero in my first number of zip code
When I put in the zip code in one of my columns it automatically takes out
the zero when that is the first number in the zip code. I am trying to keep a NJ zip-07871 and it keeps coming back as 7871 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep a zero in my first number of zip code
Your cell is currently formatted as a number. Format as a text and it will
keep the zero. "raindrop6027" wrote: When I put in the zip code in one of my columns it automatically takes out the zero when that is the first number in the zip code. I am trying to keep a NJ zip-07871 and it keeps coming back as 7871 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep a zero in my first number of zip code
Right click
Format cells On Number tab click Special You will see Zipcode You can also format zipcode +4 "Rich Stanek" wrote: Your cell is currently formatted as a number. Format as a text and it will keep the zero. "raindrop6027" wrote: When I put in the zip code in one of my columns it automatically takes out the zero when that is the first number in the zip code. I am trying to keep a NJ zip-07871 and it keeps coming back as 7871 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| Text formatting | Excel Worksheet Functions | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| how do i create an access code sheet to number my office files an. | New Users to Excel | |||
| Format the Cell into a telephone number but using country code | Excel Discussion (Misc queries) | |||
Linear Mode
