2 Replies Latest reply: Sep 27, 2012 6:10 PM by Rob Wunderlich RSS

    How do I remove preceeding zero's from Numbers

      Hello, in the data base I work with I have a mix of numbers where some have preceeding zeros and some dont for example.

       

      0000001311551 >>1311551

      0000000454545 >>454545

      1254550000101>>1254550000101

      0000000045454>>45454

       

      The numbers after the >> are the way I want to see the numbers in my report, How do I go about this?

       

      Thanks.

       

      Paul.