Delete part of a formula (ROUND)

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.

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.

baool wrote:
>
> 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.
>
> --
> baool
> ------------------------------------------------------------------------
> baool's Profile: http://www.excelforum.com/member.php...o&userid=37597
> View this thread: http://www.excelforum.com/showthread...hreadid=572200

--

Dave Peterson