Thread: Excel drops my lead zeros: need 0051 not 51
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default Excel drops my lead zeros: need 0051 not 51
Custom format 0000 or preformat as text and AFTER you have formatted as text
type 0051

--


Regards,


Peo Sjoblom


"Monet" wrote in message
...
Please help me to format the cell to view and print with the lead zeros


Reply With QuoteReply With Quote