How can I display numbers with 3 digit all the time ?
Like 1, 2, 3, 10, 125 → 001, 002, 003, 010, 125
Pierre,
Solved
Format '1' --> '001' Formula?
Best answer by Kamille_Parks11
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.
+27RIGHT("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.
+17RIGHT("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.
Right, so if you need to do any subsequent adjustments to the data, just wrap the field reference inside a VALUE() formula.
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.
Thank’s a lot guys ! :grinning_face_with_big_eyes:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.