You need to sign in to do that
Don't have an account?
arasu
How can we format number fields to pad zeros to the left?
Hi,
How can we format a custom number or text field to pad zeros (0) on the left of a 5-digit number.
For e.g: If user enters 346, then it should be saved and displayed as "00346".
For e.g: If user enters 346, then it should be saved and displayed as "00346".
Thanks and regards,
Ambili
Ambili
You can use the lpad formula
For instanceTo 'pad' out a day to always be two digits try:-
lpad(text(day(UsageEndDate)),2,'0')