Convert Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
D said:
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,
Click to expand...


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

Tom Lake
 
Perfect!! Thank you Tom!

Tom Lake said:
D said:
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,
Click to expand...


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

Tom Lake
Click to expand...
 
Back
Top