Add leading Zeros to number

[jack]

Hello,

I have a number that is 6 places long.

I would like:

"16" to be "000016"
"116" to be "000116"

and so on.

Any help whould be great!!

Thanks,

Jack

 

[Mark Keogh]

Number.ToString.PadLeft(6, "0"c)

 

[jack]

Hello,

Thanks for the quick reply. How do I have the formating done on a var like
CounterCount?

Thanks,

Jack

 

[Mark Keogh]

Exactly the same,

CounterCount.ToString.PadLeft(6, "0"c)

HTH

 

[jack]

Thanks!!!

Exactly the same,

CounterCount.ToString.PadLeft(6, "0"c)

HTH

 

[Herfried K. Wagner [MVP]]

Hello,

I have a number that is 6 places long.

I would like:

"16" to be "000016"
"116" to be "000116"

and so on.

Any help whould be great!!

\\\
MsgBox(Format(16, "000000"))
///

HTH,
Herfried K. Wagner