Round the whole worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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?
 
If the worksheet is prepared and I want to show all the figure nearest 100.
Can I use the number format to display?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers as Text 4
rounding a formula with sum 5
How to round values from formulas to whole dollars 1
Not rounding when I do not want to display 0's 5
Round up this formula 3
Format cell to the nearest 100 4
Round formula 1
Conditional formatting using part of the cells contents 3

Back
Top