Hello,

I have recently taken on a new role, and it involves using a lot of Spreadsheets set up by my predecessor. The problem I have is that he never used the Round,2 function and as a result i get a lot of "false" returns when using the information as the results are e.g. 13.000001. I can use a ctrl shift 1 to make it look correct to 2dp, but is there a way of mass formatting the spreadsheet to give results in 2DP.

Any help would be appreciated.

R's

Om