5 Replies Latest reply on Jan 29, 2010 3:34 AM by LaRetta_1

    Leading Zero's Padding



      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.