Thread: why is the zero falling off a zip code in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default why is the zero falling off a zip code in excel?
Excel eliminates leading 0s by default.
See this for help,
http://groups.google.com/group/micro...c53a3fddb34000
, or format your cells as text.

--
Brevity is the soul of wit.


"Pam" wrote:

I am doing a spreadsheet in excel and in the zip code field the zero is
falling off the front. it is 08015 and it keeps changing to 8015. can
anyone tell me why?
Reply With QuoteReply With Quote