AnsweredAssumed Answered

Formatting Number String with Decimal

Question asked by jared944 on Dec 3, 2013
Latest reply on Dec 3, 2013 by jared944

Title

Formatting Number String with Decimal

Post

     Hello everyone,

     I have a table with a keyfield that contains a series of numbers with either four or five digits : 

     1234

     12345

     I would like to create a script that would insert a decimal after the third digit :

     123.4

     123.45

     The table has over 10,000 entries, so doing this by hand would not be the most effective way to do this. Any help would greatly be appreciated.

      

     Thanks!
      

     Jared

Outcomes