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?