Why is Excel rounding when I truncate?
 

I have a formula:

=L2*M2*0.00125

this gives me the number 252.96

if i truncate to zero decimal places using cell formatting it returns
253??? Also if the value is 252.46 it truncates to 252? How is it
doing this?
I though truncating meant removing the extra decimals not rounding.

Why is Excel rounding when I truncate?
 

How do you truncate using formatting?

=TRUNC(L2*M2*0.00125)


--


Regards,


Peo Sjoblom


wrote in message
...
I have a formula:

=L2*M2*0.00125

this gives me the number 252.96

if i truncate to zero decimal places using cell formatting it returns
253??? Also if the value is 252.46 it truncates to 252? How is it
doing this?
I though truncating meant removing the extra decimals not rounding.