Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formating Worksheet Cells
?
How do you format a worksheet to format all cells to round numbers to 2 decimal places. I am not talking about the cell format command that display numbers. I am trying to have the speadsheet round all numbers. I know that Round(Range("A1"), 2) will work on an indivdual cell. Can this be applied to the enetire work sheet or range of cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
How do I link a cells formatting from one worksheet to another? | Excel Worksheet Functions | |||
Can I lock a set of cells in a worksheet? | Excel Discussion (Misc queries) | |||
Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
Making cells compulsary to fill in on a worksheet | Excel Discussion (Misc queries) |