Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
@ Round Formulas
John,
Not sure if this is what you are looking for, but... If you go to Edit Special Formulas you will select only those cells with formulas. (You may want to hit Delete, first, to clear the cells) Type in your formula (make sure it is relative reference where you need relative reference). Than hold the Ctrl key and hit Enter. The formula will fill to all cells in the selection (and adjust the references). Note that this will change all formulas. -- sb "John M" wrote in message ... Hello, I have numerous formulas that I need to convert to @round. Does anyone know of a fast way to do that? I tried an "edit/replace" technique but that did not work since all the formulas are different. Any advice would be much appreciated. John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a column of formulas all ROUND | Excel Discussion (Misc queries) | |||
How to round values from formulas to whole dollars | Excel Discussion (Misc queries) | |||
Round formulas | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
How do I round up or down using formulas? | Excel Worksheet Functions |