Format with the number of digits

For instance

FormatCellsCustom and input 000000

--
HTH

Bob Phillips

"Columbus Excel User" <Columbus Excel wrote
in message ...
I am working in Excel and would like to show leading zeros in cells that
have
been formated as number cells. Is this possible and how is it done?