2 Replies Latest reply: May 15, 2014 10:12 AM by a2z143 _ RSS

    Leading zeros

    a2z143 _

      Need help! I'm tryin to add leading zeros to a field by creating a new calculated field (Numeric) and need a formula to add leading zeros (field length 7):

       

      this what i have:

       

      17120

      21280

      8120

      4704

       

      expected results:

       

      0017120

      0021280

      0008120

      0004704