Thread: Decimal Point
View Single Post
  #1 (permalink)  
Old March 15th, 2005, 11:11 AM
interrupt interrupt is offline
Friend of Wrox
Join Date: May 2004
Location: , , .
Posts: 212
Thanks: 0
Thanked 0 Times in 0 Posts
Default Decimal Point

Hi all,

I am pulling values from an Excel file into a div. (thanks Joe Fawcett). Now, the next problem I have is that the values are percentages, and when they are displayed in the div, they are about 15 characters long and the decimal is in the wrong place. So instead of getting "95.04%", I am getting "0.9504034537733". Is there a function I can use to get rid of some of the numbers and move the decimal point along 2 places? I would be looking for something like this if it exists:

document.getElementById("divOutputA").innerText = oWS.Range("AF67").value.TrimNumbersAndMoveDecimalF unctionHere();

Once again TIA

\'sync\' <cr>
The name specified is not recognized as an internal or external command, operable program or batch file.