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.