How do I keep a zero in my first number of zip code

R

raindrop6027

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
 
R

Rich Stanek

Your cell is currently formatted as a number. Format as a text and it will
keep the zero.
 
R

RealmSteel

Right click
Format cells
On Number tab click Special
You will see Zipcode

You can also format zipcode +4
 
Top