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.
Bookmarks