Apply Round Formula to Multiple Cells

[gaofun]

Hello all,

Apologies if this has come up before but I did a quick search and couldn't find it.

I have a range of cells with formulas already I want to apply =round( "formula",0) for and I was wondering what the fastest way to do that would be instead of typing it out. The formulas in the range are all a bit different so I cannot so I cannot simply copy and paste. Any suggestions would be appreciated.


I'm using 2016 excel.

[samba_ravi]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[José Augusto]

Hi

You can try this VBA code with selection to do that, but make a backup of your file first. Change numberdimals as you wish.

Please Login or Register  to view this content.