Is There An Alternative Way

[Delta Star]

I currently have data in cells P2:EB24691 which I have to round to two decimal places. An example being 0.0457641202567814 becomes 0.06. I currently create a formula in another sheet and then copy and paste as values the data back into the original sheet.

I was wondering if there was an alternative method to update the cells directly without using another sheet?

This is the formula I currently use

=ROUNDUP('Monday'!P2,2)

 

[Dryver14]

you could select the whole sheet and reduce the decimals for all cells

 

[Dryver14]

the above does not change the number though, just the view

 

[RichardMGreen]

There's also a "Precision as displayed" option in the Tools/Options menu. But that means you lose the rest of the data permanently.