Add zero before a one digit number

[veles]

I have fields with numbers from 1 to 99 and I need help with a formula to have the field with an one digit number to add a zero in front only if it is a one digit number and not add a zero if it is a 2 digit number.
Example:
1.1.12 to be 01.01.12

All digits before and after the dots are from different number fields that I will concatonate.

Thanks for your help

 

[lbass]

Your formula should look like this:

totext({table.number1},"00")+"."+
totext({table.number2},"00")+"."+
totext({table.number3},"00")

-LB

 

[veles]

Thank you very much. It worked like a charm