Formula to add 0 to the left side of a number

1

Hi. I need a formula to add 0 to the left side of a number, so that it always ends up with 3 digits.
For instance 1 => 001 15 => 015 134 =>134.
Is there a simple way of doing it. (Maybe using RegexReplace() ).
I didn’t want to use if()/concatenate() for this case.

2

Use the LeftPad formula.

LeftPad([Column],3,“0”) should get you there

1 Like
3

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