Round the whole worksheet

H

Hung

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!
 
D

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?
 
H

Hung

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