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