Ben SmithBen Smith
Ben Smith/
Leading Zeroes
Leading Zeroes
Leading Zeroes

Leading Zeroes

For
From
Status
Updating
Formulas
+
+
format
format
length
length
slice
slice
-
-
Share
Entries

Formatted

if(length(format(prop("Number"))) == 0 or contains(format(prop("Number")), "-"), "", slice("00000", 0, 5 - length(format(prop("Number")))) + format(prop("Number")))
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!