Format '1' --> '001' Formula?

How can I display numbers with 3 digit all the time ?
Like 1, 2, 3, 10, 125 β†’ 001, 002, 003, 010, 125

Pierre,

RIGHT("000" & {Field Name with Original Number}, 3)

^ that will get you the format you want, but the result will be treated as a string as opposed to a number.

4 Likes

Right, so if you need to do any subsequent adjustments to the data, just wrap the field reference inside a VALUE() formula.

1 Like

Thank’s a lot guys ! :smiley:

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.