FormatCellsNumberCustom In the Type box, enter 00000

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"spoggy" wrote in message
...
doing worksheet for ordering zeros at beginning of numbers disappear. How
do
I format to keep zero in group of numbers ie 04581