Round large volume of data to 4 decimal places

Hi all,

I'm pretty sure there is a way to do this with the paste-special function.


I have a reasonably large volume of data - about 2,000 rows and 22 columns.

The columns all contain various percentages with differing decimal places - some up to a dozen decimal places coming from an external source.

There are no links - the percentages are all hard coded.

I want to change all the percentages to a number with four decimal places. I can use a round function and do it one column at a time but I'm pretty sure I'll have the same problem in several other renditions of the file so am looking for a quicker way to copy and paste numbers to four decimal places.