### Title

Number formatting

### Post

How do I make numbers less than a hundred have trailing zeroes. e.g want 5 to appear as 005, 12 as 012 and 235 as itself ? thanks

regards

Kaps

Number formatting

How do I make numbers less than a hundred have trailing zeroes. e.g want 5 to appear as 005, 12 as 012 and 235 as itself ? thanks

regards

Kaps

You will need two fields. One field where you enter the number. And a calculation field that adds the leading zeroes.

Let's say you have a field called "Number" as a number field where you enter your number.

You then make a calculation field called "c_Number_Zeroes" (for instance) where you create the following calculation:

Right ( "000" & Number ; 3 )

This means you will be combining "000" with your number.

12 will become 00012.

1 will become 0001

235 will become 000235.But the Right function takes only 3 characters from the right side.

So you will always end up with 3 characters and leading zeroes.

You will need two fields. One field where you enter the number. And a calculation field that adds the leading zeroes.

Let's say you have a field called "Number" as a number field where you enter your number.

You then make a calculation field called "c_Number_Zeroes" (for instance) where you create the following calculation:

Right ( "000" & Number ; 3 )

This means you will be combining "000" with your number.

12 will become 00012.

1 will become 0001

235 will become 000235.

But the Right function takes only 3 characters from the right side.

So you will always end up with 3 characters and leading zeroes.