cell reference not displaying value

[bluegrassstateworker]

I have received a spreadsheet from someone else that is acting
strangely, perhaps someone can help. If I make a reference to another
cell, say I am in cell R3 and want to imput the value of A1, I would
simply input =A1 in cell R3 and the value of A1 is displayed: no fuss,
no muss.

When I try this (numerous ways) the formula itself is displayed. Any
ideas??

 

[Dave Peterson]

Try selecting that cell
format|cells|number tab|General (or anything but Text)
then hit F2 followed by enter.

If that doesn't work, try:
tools|Options|View tab|make sure Formulas isn't checked.

 

[L. Howard Kittle]

You may have the cell formatted as text. Format as General and re-enter
your formula

HTH
Regards,
Howard