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

# 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
• ###### 1. Re: I need help moving a decimal place
Mulitply it by 10.
• ###### 2. Re: I need help moving a decimal place
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
>
>

• ###### 3. Re: I need help moving a decimal place
Brilliant and I feel like a 1st grader now :)
Thanks Dan.

Terry
• ###### 4. Re: I need help moving a decimal place
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. :)
• ###### 5. Re: I need help moving a decimal place
Ha! That's an excellent point.
Terry