AnsweredAssumed Answered

Leading Zero's Padding

Question asked by shogun on Jan 24, 2010
Latest reply on Jan 29, 2010 by LaRetta_1


Leading Zero's Padding


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.