formulas show up instead of values

S

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?
 
M

Michael Hopwood

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

Gord Dibben

Sherry

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

Gord Dibben XL2002
 
Top