### Title

Is there a way to display one digit numbers as two digits?

### Post

Hi everybody,

Is there a way to display one digit numbers as two digits?

Like: 3 as 03

thanks

Is there a way to display one digit numbers as two digits?

Hi everybody,

Is there a way to display one digit numbers as two digits?

Like: 3 as 03

thanks

I've used the Right function like Rick did for years. Recently, Comment pointed out another function that works for this:

SerialIncrement("000";YourNumberfield)

will format with leading zeroes as well.

For simply formatting the number, I don't see any real advantages/disadvantages between the two functions. However, SerialIncrement has other features that may make it more advantageous when you are also performing math operations on your value.

A few ways, BUT I like to create a second field and do something like this:

then add a final field to combine the two together:

Your result will be a 2 digit number.

Other ways to do this, but often I have more logic involved to fix credit card expiration dates to be formatted properly.