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.

Use the LeftPad formula.

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

1 Like

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