5 Replies Latest reply on Sep 9, 2008 6:37 AM by WhozitsPop

    I need help moving a decimal place

    WhozitsPop
      Good morning all. I have the following that needs manipulating. The first set of numbers is the raw data I have access too.

      Latitude: 3.13929
      Longitude: -8.14461

      I need it formatted like this:

      Latitude: 31.3929
      Longitude: -81.4461

      I need to move that decimal place to the right one spot. Any ideas? I have thought of REPLACE, create new value and insert but my head hurts. I just need some ideas.

      Thanks
      Terry