Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Existing Formulas/Values
I have a worksheet with thousands of cells that reference many other
worksheets in the workbook or are formulas. I need to round all of the values in the worksheet to 2 decimal places (not just display but the actual value), but I don't want to change every cell to include the Round function. Is there a way to do a mass change to round values? Thanks for your assistance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Existing Formulas/Values
Hi,
1. Change the Format of all the cells to 2 decimal places 2. Choose the command Tools, Options, Calculation, Percision as displayed -- If this helps, please click the Yes button Cheers, Shane Devenshire "The Project Master" wrote: I have a worksheet with thousands of cells that reference many other worksheets in the workbook or are formulas. I need to round all of the values in the worksheet to 2 decimal places (not just display but the actual value), but I don't want to change every cell to include the Round function. Is there a way to do a mass change to round values? Thanks for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I insert a row and have the existing formulas apply? | Excel Discussion (Misc queries) | |||
How do I insert a row & have the existing formulas apply to new ce | Excel Discussion (Misc queries) | |||
How can I insert a row and have the existing formulas apply? | Excel Discussion (Misc queries) | |||
How can I insert a row and have the existing formulas apply? | Excel Discussion (Misc queries) | |||
How do I add another name to an existing table with formulas to w. | Excel Worksheet Functions |