### Title

Leading Zero's Padding

### Post

Hello -

Need help with the formatting of a conditional formatting formula to pad a number with leading zero's so that the results of a field always displays 3 digits.

Example, if a user enters "7" in a field and clicks off the field the result displayed would be "007". If the user entered "27 then the result would be "027" and if the user entered "127" the result would be "127".

The number would never be greater than three digits.

Thanks for your assistance.

-S

Try auto-entering a calculation (replacing existing data) =

SerialIncrement ( "000" ; Self )