cell reference problem

D

David Funnell

I am trouble with cell references in a spreadsheet. Some cells will
display the cell reference rather than the value it points to.

For example the cell will display =A1 as text rather than the content
of that cell.

What could cause this????????

thanks in advance david
 
D

David McRitchie

Hi David,
First check that you have calculation turned on.
Tools, Options, Calculation, automatic calculation

If that is the problem and it recurs, see my slowresp to see
how to spot the problem earlier.

The other possibility is that you have Text formatting instead
of General or a numeric format.

Other things to try:
F9 for recalculation, but if you have automatic and it is not
working try the shortcut Ctrl+Alt+F9 which
Recalculates all cells on all worksheets in all open workbooks.

Does F2 then Enter work, there are several ways of correcting
problems having to do with reentering. A non macro solution after
changing the format from text to a valid format is to change "=" sign
to "=" sign.

If it still does not work perhaps your formulas have a space or
other character in them. See the TrimALL macro and the
descriptions near it.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
 
Top