I have a matrix of numbers in Excel consisting of numerical data. I want Excel to display each cell rounded to 5 significant figures.
How would I go about this? Is it possible to perform the rounding on all cells at once?
I have a matrix of numbers in Excel consisting of numerical data. I want Excel to display each cell rounded to 5 significant figures. How would I go about this? Is it possible to perform the rounding on all cells at once? 


If your matrix is in A1:D10 then you can create a "rounded matrix" adjacent to that, e.g. in G1 use this formula
copy down and across to J10 to get your new data rounded to 5 significant figures in 

