This won't affect calculations unless you have the Precision as
displayed checkbox in Tools/Options/Calculation checked.

Note that it still won't prevent all rounding errors.


In article ,
wrote:

yes it is possible.
select the whole sheet by clicking the small square in the
upper left corner of the sheet(above the 1 and beside the
A) then format to 2 descimals.