Formula displays, not value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am linking two files by having cells in one spreadsheet equal to
corresponding cells in another. However when I enter the equal sign in one
sheet, then go to the other sheet and click on the corresponding cell then
hit enter, the original cell displays the formula, not the value. I tried
copying cells above which display correctly, but that does the same thing.
Any ideas how to solve this problem?
 
Evening. Make sure that your calculations haven't been switched to "manual"
by the gremlins (an errant keystroke). Go to Tools/Options/Calculations.
Each time this has happened to me, that's been the culprit.
 
Hi there, I'm having the same problem with cell copying. Calculations is set
to automatic, the format is set to date and the cell I'm copying from is the
same, any other suggestions? Thanks
 
Kimo

Perhaps the receinving cells are formatted as text.

Format to General then F2 and ENTER to re-enter the formula.

Or you have View Formulas enabled.

Hit CTRL + ` (backquote above Tab key) to toggle out of formula view.

Another trick.................select the cells and Edit>Replace

What: = sign

With: = sign

Replace all.


Gord Dibben MS Excel MVP
 
Back
Top