Set the format (FormatCellsCustom) to 0000000

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"PhilM" wrote in message
oups.com...
How to a force VBA to show an integer as a fixed number of digits? eg
display 240 as 0000240