View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Format the range with the required number of zeroes, such as 000.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dvs" wrote in message
...
When I type a number in the "General" format with a zero in front of the
numbers and move to the next cell, the zero disappears. I want the zero

to
be in front of the number.

How do I fix this?