msgbox Format(example,"000000")

--
Regards,
Tom Ogilvy

"TJF" wrote in message
...
Hello,

I need declaration variable like this:

dim example as ???
example = 155
msgbox example
------------------------------------
And I need this result: 000155
------------------------------------
example = example + 1000
------------------------------------
And I need this result: 001155
------------------------------------

in range I cen use Selection.NumberFormat = "000000", but how its work
when
I want use this in variable.

Thanks Tom