A number always with two digits as text (formula)

i get the day of a date in a formula with day().
i need this number allwas with 2 digits as a text (f.e. “05”)
i thought, i use ‘text(day(…),“00”)’ but it doesn’t work. I can’t find anything in the documatation.
Can anybody help me?

This is a bit too simple.

Try this:


Then make sure that the result type is recognized as “string”.

OK, I thought it would be simple :slight_smile:
Thanks for this solution, it works
Simple formatting with the “text” command might be something for the future

The purpose of text is different.

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