Thread: How do I keep a zero in my first number of zip code
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
RealmSteel RealmSteel is offline
external usenet poster
  
Posts: 5
Default 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 With QuoteReply With Quote