Go to Format Cells Number tab and click "Custom".
Under "Type" put: 0000000
HTH
Jason
Atlanta, GA
-----Original Message-----
I am trying to display a number (eg 123456) with a 0
(zero) at the beginning
(eg 0123456). Since excel does not display an
insignificant zero by default,
can anyone tell me how I can do this and apply the rule
to a list of cells
that already contain a 7 digit number without having to
re-enter the
information.
.
|