Depending on how you formatted the cells, you might consider

ToolsOptionsCalculation tab, check Precision as displayed. Look in HELP to read the consequences.

--
Kind regards,

Niek Otten

"fak119" wrote in message ...
| Is there (or can there be) a macro or a function that changes a formula like
|
| =C1*$R4 in =round(C1*$R4;0) etc.
|
| I have many spreadsheets with hundreds of formulas on each sheet that need
| to be rounded. I would have to change individually every single formula. Is
| there an easier way?
|