Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Michelle wrote:
I am working with a fairly large spreadsheet I inherited that contains the ROUND function in several cells. Two questions: (1) How do I remove the rounding function w/o disturbing the formula. (2) Is there a quick way to remove it w/o going into every cell? "Quick" way? I would say "no". First, I would write a macro to automate this. But such a macro is "quick" to do only if we can make some assumptions; for example, all the formulas that you want to change are of the form =ROUND(...). The more general case of ROUND(...) appearing anywhere within a formula and potentially more than once requires complext parsing algorithms. The tricky part is finding the balancing right parenthesis as well as the 2nd parameter, both of which must eliminated along with "round(". (But perhaps someone has one already written such a macro.) If it is only "several" cells, I would think the "quickest" way is indeed to simply visit each cell and edit it manually, removing "round(" on the left and ",...)" on the right. Perhaps what you would like is an easy way to find all the cells that contain at least one use of "round". Use the Edit Find Find All feature. Type ctrl-A to select all the cells (or select a range of interest), then click Edit Find, fill in "round", and click Find All. You can then click individual cells in the Find All result, and edit each cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can you nested sum and round function within if function? | Excel Worksheet Functions | |||
Round function that rounds down if 5 | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
help with round function | Excel Worksheet Functions |