Round all values on sheet

**Lee Hutchinson** · 10-30-2012, 07:50 AM

Hi,

I am trying to select an entire range on a sheet and round all values to nearest 1. The sheet has been forced to round by formatting the cells to 0 decimal places but I need it done properly as I need to use the result in something else. So in example cell D4 has a value of 13.11122 i want to ROUND(D4, 1) which clearly works but the sheet in question has 144 columns so I don't want to do this manually.

Any help appreciated.

**martindwilson** · 10-30-2012, 07:56 AM

if you have formatted cells to 1 decimal place then in options you can turn on precision as displayed this will set them all to what you can see then once done turn it off,they will stay fixed