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

    Leading Zero's Padding

    shogun

      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