Reducing Number Precision

L

lcs34

I have a large worksheet made up of numbers of high
precision - about 8 decimal places. Is there a way I can
reduce this in excel to say 2 decimal places as I do not
require a precision higher than that?
 
P

Peo Sjoblom

If they are formulas you can use

=TRUNC(A1,2)

if they are constants you can use a number format with 2 decimals,
then apply temporarily tools>options>calculations and precision as displayed
Note that the latter will round the second digit. Then you can remove it
 
Top