Thread: why is the zero falling off a zip code in excel?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default why is the zero falling off a zip code in excel?
Pre-format the cell(s) as TEXT or type a leading apostrophe before typing the
zip with the leading zero........

Vaya con Dios,
Chcuk, CABGx3



"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