Delete part of a formula (ROUND)

[baool]

My question has to do with the ROUND formula.

I have a worksheet (FILE A) that is linked to another worksheet (FIL
B) but the formula for the link is the ROUNDED number [i.e
=ROUND(FILEB(A1),-0.5)].

The problem is that I have this linked formula for a number of cells i
the worksheet and also in multiple worksheets within the same workbook
all the ROUND formulas are linked to the same source (FILE B).

Is there any quick way to get rid of the ROUND part of the formula s
that I am left with only the direct link to the other worksheet?

Please help

 

[Dave Peterson]

That doesn't look like a real formula to me.

You may want to post a few examples--especially if they vary--to see if you get
good responses.

In fact, you may want to post a few formulas both before and after.

My question has to do with the ROUND formula.

I have a worksheet (FILE A) that is linked to another worksheet (FILE
B) but the formula for the link is the ROUNDED number [i.e.
=ROUND(FILEB(A1),-0.5)].

The problem is that I have this linked formula for a number of cells in
the worksheet and also in multiple worksheets within the same workbook;
all the ROUND formulas are linked to the same source (FILE B).

Is there any quick way to get rid of the ROUND part of the formula so
that I am left with only the direct link to the other worksheet?

Please help.