14 Replies Latest reply: Dec 8, 2017 6:55 PM by Caroline Acosta RSS

    Adding text numbers with Leading 0

    Caroline Acosta

      Hello!  I hope someone can help me on this.  I want to add 2 fields in text  and number format.  However , I want the results in text format with leading 0 as shown below "Result"  column...Thus, the results should be in Seq field format.

       

      I tried  Text(Num(Seq+counter,Repeat('0',Len(Seq))))  to no avail ...

       

         

      SeqcounterResult
      000410005
      0032005
      02103
      123
      213
      00005200007

       

       

       

      Thank you in advance.