Convert Number

[D]

Hi:

If I have a number: 123; I would like to convert to CA000123 - must be 8
characters long; how do I get the zeros in front of the number, to have a
total of 8 char.?!

Thanks a lot,

Dan

 

[Tom Lake]

Hi:

If I have a number: 123; I would like to convert to CA000123 - must be 8
characters long; how do I get the zeros in front of the number, to have a
total of 8 char.?!

Thanks a lot,

"CA" & Right("000000" & [YourNumber], 6)

Tom Lake

 

[D]

Perfect!! Thank you Tom!

Hi:

If I have a number: 123; I would like to convert to CA000123 - must be 8
characters long; how do I get the zeros in front of the number, to have a
total of 8 char.?!

Thanks a lot,

"CA" & Right("000000" & [YourNumber], 6)

Tom Lake