3 Replies Latest reply on Mar 14, 2016 7:46 AM by Carl Slifer

    Need help creating a calculated field

    Brian Mandel

      Hello,

       

      I have a dimension that is 6 characters long, but are all numbers and need to insert a decimal, or period after the second number.

       

      So, it's currently formatted

       

      040201

      131129

      190215

       

      And I need it to be

       

      04.0201

      13.1129

      19.0215

       

      I'm assuming a calculated field would be the best way to do this, but I'm open to other options too.

       

      Thanks