Add round formula in existing formula

[rchure]

Hi Team,
I want to add "Round" formula to existing formulas in the workbook. So I had find and replace the the formula but i am getting error. Please find attached the error screen shot. Could you please help me how to add "Round" forumla to existing Formula?
Thanks,
Rahul

[Jacc]

If you post a workbook with some sample data it will be much easier to help you.

[rchure]

Hi Jacc,
I have attached the sample excel worksheet. In the worksheet i have highlighted the formula by "Yellow" colour under Sheet1,2 & 3.
now I want to add "Round" formula to each formula in that worksheet and I am trying to replace each formula with Round but i am getting error. So any shortcut to add "Round" formula to cell which i have formula.

Thanks,
Rahul

[alansidman]

Here is one I have used for years. Highlight the cell you want to round and employ the macro.

Please Login or Register  to view this content.

You can add this to a shortcut key if you want.

[rchure]

Hi Alan,

Thanks for the reply.

Your code only round off the figure for the Activecell which i have formula. I want all the cell round off once i run the macro in that worksheet which had formula.

And also i want to show 2 digit decimal in round off forumala.

Thanks,
Rahul