Back to zzTakeoff Community Channel LogoQ & A
Kyle Bonde - Vertical GC
1h 39m

Leading Zeros and Alpha Numeric Sorts

Anyone Know how to write a formula to always add a "0" if its only 1 digit?


Example I want the below to day "04"


0
Kyle Bonde - Vertical GC 1h 23m

wow love chat gpt helped me! All you have to know is zzTO uses math.js and can solve many of your problems. Here is what I used:


concat(if([width:IN] < 10, "0", ""), string([width:IN]), '"')


Lorin Allred zzTakeoff53m 40s

Awesome!! Glad you figured it out, and thanks for sharing. 🙂

You must be logged in to post replies. If you don't have an account you can signup here.