ExcelBanter - Round the whole worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Round the whole worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/17823-round-whole-worksheet.html)

Hung

Round the whole worksheet

How can I round or format the whole worksheet?

e.g.
5.01 - 0
15 - 0
100 - 0
1123 - 1100
1567 - 1600
21220 - 21200
45678 - 45700

Thanks!

Dave O

The formula to round in this manner is
=ROUND(#, -2)

The # can be a cell reference or a hard-coded number.

Do you need to apply it to an entire sprdsht?

Hung

If the worksheet is prepared and I want to show all the figure nearest 100.
Can I use the number format to display?

"Dave O" wrote:

The formula to round in this manner is
=ROUND(#, -2)

The # can be a cell reference or a hard-coded number.

Do you need to apply it to an entire sprdsht?

All times are GMT +1. The time now is 06:48 PM.