View Single Post
  #4   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Jeff,

Format - Cells - Number - Custom tab:

0000000
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jeff" <no_em@ilplease wrote in message ...
I'm sure this must be a basic question: I need to have numbers in a
particular column which begin with three leading zeros as in 000123 but
Excel automatically discards them. I can't find a format in the number
category which retains them. How do I do it please?

Thanks