Format numbers with leading zeros ?

[Nader Belal]

Hi everyone,

Here is a simple question, how to convert integer numbers to strings with leading zeros using str or str{2} functions ?

ex:
1 to be show as 01 or 001

[Karl Ottenstein]

If the format string for the STR function was like normal programming languages, this would be easy, but alas it is 'unique' and seems to have no way of producing leading zeros.

[Laszlo Nagy · Accepted solution]

After you converted it, you should inquire the length of the string (which will be 1, 2, or 3), and depending on that value, fill the beginning of the string with leading "0" characters.

[Nader Belal]

Thank you all