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?
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
Perfect, thanks Joe!