Have you tried changing the cell to General (or Number)
Then select that cell and hit F2 followed by enter.

Changing the format of a cell isn't enough. You have to reenter the
formula--Hitting F2, then enter does that.

If you have lots of these cells to fix.

Select the range to fix
format|cells|number tab|general (or anything but Text)
And then
Edit|replace
what: = (equal sign)
with: = (the same equal sign)
replace all

Changing the equal sign will tell excel that you "changed" the formula and excel
will reevaluate each of those cells.

Delos wrote:

I have a workbook (created by someone else...ugh) that uses links to another
workbook (an answer sheet), no longer available. I have a new version of the
answer sheet, but when I try to edit the cells in the first workbook, they
will only display the formula itself of the actual link.

e.g., the cell displays: ='[ITEMS for MC TABLE REV1.xls]ITEMS SORTED'!$F$12

Nothing short of Edit/Clear/Formats seems to let me redo these links. Oh, it
lets me change the link, but then simply displays the link as text, just as
it did the previous link. Also, I can't even add a new link anywhere on the
worksheet, until I clear the formats. One clue might be this: the cells in
question are set to Text format, as the text is a decimal number (such as
415.99). I've tried just changing the cell's Number format to something else,
but no joy. I've also tried unprotecting cells, the sheet, unlocking cells,
etc. No joy.

Any ideas?

--

Dave Peterson