How do your remove ROUND function?

[Guest]

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?

 

[Guest]

What do the formulas look like? Are they all similar length wise?
Perhaps give us at least one example of one of the formulas.

 

[teelim]

Try this:

Select the whole sheet (CTRL + A) and use the "Find & Replace" (CTRL +
H) command. In the "Find" field, key in ROUND and leave the "Replace"
field blank and click on "Replace All"

*VERY IMPORTANT!
-When doing this, make sure that the sheet only has the ROUND function.
If it also has ROUNDUP and/or ROUNDDOWN, make sure they are "Replaced"
first before you get rid of ROUND to avoid any complications.

hope this helps

 

[joeu2004]

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.