I have a number from 0 to 99 that I want to convert to text, retaining the leading zero.

For example,

0 should become “00”

1 should become “01”

22 should become “22”

I have a number from 0 to 99 that I want to convert to text, retaining the leading zero.

For example,

0 should become “00”

1 should become “01”

22 should become “22”

Use this formula:

Right(Text(100+[myNumber]),2)

Here is how it works. Let’s take number 3 as an example, we want it to become “03”.

100+ 3 = 103

Text(103) = “103”

Right(“103”,2)= “03”