Try this:

FormatCellsNumber
Category: Custon
Type: 00000000
Click [OK]

Note: that won't actuall prepend zeros to the the numbers. It will just
display zeros where needed.

Does that help?
--
Regards,
Ron