number rounding in MS Excel

[mahusain]

Hi,

This may have been answered many times.

In MS EXCEL is there a way that it calculates all numbers to 2 decimal
digit accuracy instead of the 15 digit default?

Thanks in advance for the answer.

 

[Andy B]

Hi

You can set your decimal places in your cells as 2 and then check Precision
As Displayed on the Tools / Options / Calculation page. Be careful though,
it means what it says!!

 

[AlfD]

Hi!

No. But you can achieve the same effect if you use Tools>Options
Calculation and check Precision as displayed.

If you format a cell to use 2 d.p., this will permanently change th
number to 2 d.p. (with consequent loss of accuracy).

Al

 

[Paulw2k]

if you are getting external data, apply the ROUND function in an adjacent
column