Cell.Value to 2 decimal places

Hi,

the code below takes the value of the cell which is often 3 to 5 decimal places and inputs the formula, however, how can i make VAR = only 2 decimal places insted of it absolute value
i.e.

A1 = 2.34678 So I want: -
VAR = 2.35
So the End result is
'=SUM(2.35)*(1-C10)'

NOT - '=SUM(2.34678)*(1-C10)'

as this confuses people because they keep say the calculations are wrong because it is formatted in 2 decimal places.

Cells(ROWPOS, 6).Select
    VAR = ActiveCell.Value 'assigns the current cell value to VAR
    Cells(ROWPOS, 6) = "= Sum(" & VAR & ")* (1-C10)"

Hello Jonn,

Here is the conversion code..

VAR=INT(A1*100)/100

Sincerely,
Leith Ross

what does that formula do?

Thanks

Hello Jonn,

It strips away any decimals greater than 2. The number will only contain 2 decimal numbers after the decimal point. However, it does not round the second number off.

Sincerely,
Leith Ross