Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
Solved
Jump to Solution
278 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Pierre,

1 Solution

Accepted Solutions
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.

See Solution in Thread

3 Replies 3
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.

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

Thank’s a lot guys ! :grinning_face_with_big_eyes: