Copying formula from one sheet to another

R

Ray Druian

This should be simple, but I keep getting it wrong. In a
single workbook, I have two sheets, "MASTER" and "Diagram."
A cell in "MASTER" has a number in it, say "050009," and I
want to copy it to "Diagram." So I insert in the proper
cell of "Diagram" the formula, "=MASTER!H519." What I want
to display is the content of that cell, not it's formula.
If I change the contents of the cell in "MASTER," I want
the new value to automatically appear in "Diagram," not its
formula. Can someone help?

Thanx,
Ray Druian
 
F

Frank Kabel

Hi
check if the cell is NOT formated as 'Text'. change the cell format to
'General' and re-enter this formula
 
Top