formulas show up instead of values

[Sherry]

I have data that came from a mainframe. The cells aer formated as General.
If A1 is 3 and in B1 I enter =A1, what I see in B1 is =A1 instead of 3. I've
reformated A1 to a format of number but it doesn't change B1 - it still says
=A1. I do not have view formulas turned on under Tools/Options/View. What
else could this be?

 

[Michael Hopwood]

Change the format of B1 to general (it's probably set to text at this time)

 

[Sherry]

It's set to general already. Totally confusing

Change the format of B1 to general (it's probably set to text at this time)

 

[Gord Dibben]

Sherry

Follow the advice Peo gave you in the other NG you posted to.

Gord Dibben XL2002