6 Replies Latest reply: Apr 20, 2015 10:29 AM by Jannet San RSS

    Problem with number format

    Francisco Acuna

      Hello:

      I'm having the following problem with number formats:

       

      This is the number with its original format: 123456789

      what I need to do is get rid of the last number so it can be like this: 12345678

       

      to do so, i use the following script: If(Len(number)=9,Left(number,8).

       

      The problem is when I have this number: 0123456789

      I have to get rid of the last and the first number so I can get: 12345678

       

      Help please

      Thank you very much!