Digits Formula gone wrong

[Manish_Jain11]

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]

@Manish_Jain1

Like this?

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

[Manish_Jain11]

I think this should work, Let me try.