Turning 2 into 02, 3 into 03, 7 into 07, etc

[rambizn]

Hi all,

I am working on a scenario regarding timestamps. Is there a function that turns number data types from, say 2 to 02? If it was a double digit number, this should stay constant.

For example:

2 → 02

7 → 07

14 → 14

125 → 125

6346 → 6346

9 → 09

Is there a function that allows this? I am also thinking there is a way to convert these numbers into text string, and then add the “0” if the number is < 10?

[Runcorn]

You can use if function for this. Something like this,

[rambizn]

You have been such a help to so many of my questions man. Thank you so much!!