truncuate

[jamielill]

In excel VBA I have a variable with the value

x=16.34989

I would like to have it truncated to 2 decimal places with out rounding up or down
x=16.34

Thanks
jamie lill

 

[JackDanIce]

Try:

Range("A2") = Left(Range("A1"), InStr(Range("A1"), ".") + 2)

Or depending on how your code is set up

x = Left(x, InStr(x, ".") + 2)

 

[Ruddles]

Check the TRUNC function: http://www.techonthenet.com/excel/formulas/trunc.php.

 

[jamielill]

Thanks guys