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?
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
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |