Excel Cell Reference

[Jer]

I am trying Office 2007 and in Excel I have at one attempt tried to reference
a cell in another sheet in the same workbook and another time have attempted
to reference a cell from another workbook. In both cases it only shows the
formula of the typed in reference, such as =Sheet5!A$1$ and the other was
showing something like; ='[Sales Master.xls]Sheet1'!$A$5

It is not showing what exists in the actual cells that I want it to.

Any help or ideas?? Thanks JT

 

[smartin]

I am trying Office 2007 and in Excel I have at one attempt tried to reference
a cell in another sheet in the same workbook and another time have attempted
to reference a cell from another workbook. In both cases it only shows the
formula of the typed in reference, such as =Sheet5!A$1$ and the other was
showing something like; ='[Sales Master.xls]Sheet1'!$A$5

It is not showing what exists in the actual cells that I want it to.

Any help or ideas?? Thanks JT

Your cell is probably formatted as Text. Try changing the format to
General, then click the cell, press F2 as if to edit, and hit Enter.
Does that fix it?