Question: how do you copy and paste rounded values in excel?
Answer: if it is a one off: create a new tab where each cell is calculated based on the original sheet, for example in cell A1: =ROUND(OriginalTab! A1,4) etc. Then copy paste special values back to the original sheet. to run a vba macro that would round each cell on your sheet to 4 decimal places.