I would suggest using the Precision as Displayed option available under
Tools, Options, Calculation. Make sure that all cells have the proper
number format before you set this workbook level setting. That is, if you
want a cell's value rounded to 2 decimal places for example, make sure that
that is how it is number formatted.

--
Jim
"GusDubs" wrote in message
...
|I am constantly working on spreadsheets and then realise I wish I had
entered
| the "round" function at the start. Instinctively I thought of Ctrl+H to
| replace but can't figure out how you would put a ,0) at the end.
| Also considered a macro with typing - F2, Home, =Round(,End, ,0) - but
dont
| know how to get this to work over a large range of formulas.
| Any help would be appreciated