Your formatting in Excel only affects the display of the number. The underlying value does not change. This would affect any calculations as well since the decimals will factor in.

I think to change the value, you need to use one of the rounding functions.