Question
I need help moving a decimal place
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
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
