| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Linear Mode
