This content has been marked as final. Show 5 replies
Mulitply it by 10.
Multiply it by 10:
<cfset Latitude = 3.13929>
<cfset NewLatitude = Latitude * 10>
<cfset Longitude = -8.14461>
<cfset NewLongitude = Longitude * 10>
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
"WhozitsPop" <firstname.lastname@example.org> wrote in message
> 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
> thought of REPLACE, create new value and insert but my head hurts. I just
> some ideas.
Brilliant and I feel like a 1st grader now :)
> Brilliant and I feel like a 1st grader now :)
> Thanks Dan.
Don't be *too* hard on yourself. I think decimals come in Second Grade. :)
Ha! That's an excellent point.