FORMAT_NUMBER is removing leading zeros

I am using FORMAT_NUMBER to convert a number to a string, but the leading zeros are being trimmed off. Is there a format option inherit to FORMAT_NUMBER that allows for leading zeros?

1 Like

There sure is! You can use a format like 05 to pad a number out to 5 digits, so for example, FORMAT_NUMBER(12, "05") would become 00012.

4 Likes

Perfect, thanks Joe!