Leading Zeros on Numbers when createing PDF from a Workflow

Is there an expression to pad a number with leading zeros? I know you can choose leading aeros on the data type but I want to format when printing a PDF.

For example, I want 1 to print as 0001

I cannot see a format string for the TEXT expression. Is there one?

0 5 1,631
5 REPLIES 5

Format strings for TEXT() are only for Date and Time values.

You can always manually add the appropriate amount of zeroes with IF statements.

IFS( [number] < 10 , โ€œ000โ€ , [number] < 100 , โ€œ00โ€โ€ฆ) & [number]

Thanks. Yes, similar what I used in the past.

I was just hoping for and easier option

If you set the digits as 4 with your number columnโ€™s definition, it should do that trick for your pdf.

Yes. Thanks.

I thought it wouldnโ€™t work because dates donโ€™t get formatted automatically.

But it does which is great

Youโ€™re welcome

Top Labels in this Space