Sean

If these are the same length (say six characters) go to
FormatCells...Custom and enter 000000

Otherwise, your stuck with text formatting or a leading apostrophe (same
thing really)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Sean Timmons" wrote in message
...
This has to be an easy one, but I can't find it. How do I retain the
leading
zero in a number and retain number formatting?