Format a number with leading zeros

How To
1

Hi everyone

How can I format a number as a string to have leading zeros?

I retrieve a number from Airtable, currently 10, and want to format it as a 6 character string, so 000010 in this case

Thanks
Mike

2

Welcome to the Make community!

You can do this using the built-in function replace.

For more information, do view these similar questions previously asked by other community members, which may answer your question:

Next time, please try to search this forum first for existing answers. This may help you get to the solution faster, and also help keep the forum organised. Thanks for your cooperation!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

Thank you, but yes of course I searched extensively before I asked the question!

1 Like