How to a force VBA to show an integer as a fixed number of digits? eg
display 240 as 0000240

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

Hi Phil

Assuming you want your variable myVar to hold this value:

myVar = Format(240,"0000000")

Note that this is held as a string value. If you simply want to
display 240 in your sheet in the desired format, then you need to set
the number format of the cell that holds the value:

Range("A1").Value = 240
Range("A1").NumberFormat = "0000000"

Hope this helps!

Richard

PhilM wrote:

How to a force VBA to show an integer as a fixed number of digits? eg
display 240 as 0000240