Sounds as if the cell has been formatted for TEXT. Select the cell that's
displaying the formula and format the cell with the numeric format of your
choice. Then, with the cell pointer still at the formula cell, press F2 to
activate cell edit and then press enter. The formula should now display the
results and not the actual formula.
--
Kevin Backmann


"Bonnie" wrote:

I've been working on this masive workbook and have many linking cells frm tab
to tab.

Then, for no reason (that I know of), the link formula froz.

I entered:
Master!E2 and hit enter. Instead of populating the cell with the number in
the "master" tab under E2, it just kept the formula visable in the cell.

Meaning in the actual cell, without clicking in it, it reads "Master!E2"

Any idea why it's not accepting the formula??

Thanks, Bonnie