Need to get rid of decimals (Single)

[arneweise77]

Hi everyone!

I believe this is a simple problem, but I need a simple solution as well, which I can´t figure out.

I have this single decimal variable let´s say 3,45555555 returned to me from a function, but all I need is 3,46 or something close to that.

Can someone help med solve this, the best and easiest way possible?

Thanx in advance!

Arne

 

[JuanitaC]

Try using the FormatNumber function.

Response.write(FormatNumber(num1,2))

Where num1 is the variable containing the number you wish to format and 2 is the number of digits after the decimal that you wish to display.

Here is some info from DevGuru on FormatNumber (watch for wrap on the link):

http://www.devguru.com/Technologies/vbscript/quickref/formatnumber.html

 

[SashiRaveendran]

use the round function: round(3.45555555,2) = 3.46

if you have a comma instead of a decimal point then do a replace on , to . also remember to convert from string to numerical type(if it is in this form)