Skip to main content
Known Participant
September 8, 2008
Question

I need help moving a decimal place

  • September 8, 2008
  • 5 replies
  • 453 views
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
This topic has been closed for replies.

5 replies

Known Participant
September 9, 2008
Ha! That's an excellent point.
Terry
Inspiring
September 9, 2008
WhozitsPop wrote:
> Brilliant and I feel like a 1st grader now :)
> Thanks Dan.
>
> Terry

Don't be *too* hard on yourself. I think decimals come in Second Grade. :)
Known Participant
September 8, 2008
Brilliant and I feel like a 1st grader now :)
Thanks Dan.

Terry
Inspiring
September 8, 2008
Multiply it by 10:

<cfset Latitude = 3.13929>
<cfset NewLatitude = Latitude * 10>
<cfset Longitude = -8.14461>
<cfset NewLongitude = Longitude * 10>

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Fordwebs, LLC
http://www.fordwebs.com


"WhozitsPop" <webforumsuser@macromedia.com> wrote in message
news:ga3elo$1ju$1@forums.macromedia.com...
> 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
>
>

Inspiring
September 8, 2008
Mulitply it by 10.