Digits Formula gone wrong

Manish_Jain11 · 03-27-2021 05:18 PM

Hello,

I am using formula RIGHT((“0000” & A3),4) in one of my fields to convert , say,

4 to 0004
55 to 0055
and likewise

but the problem is its converting numbers like 54321 to 4321. Which is what I dont want. Any solution ?

scott_robinson

Just use Text([your number field],“0000”)…or more zeros if your number goes higher than 9999

Actually I haven’t tested this, but I’m sure it will work.

takuya_miyai

Like this?

IF(LEN(TEXT([Number]))>4,
TEXT([Number]),
RIGHT("0000" & TEXT([Number]),4)
)

Manish_Jain11

I think this should work, Let me try.