formulas show up instead of values

  • Thread starter Thread starter Sherry
  • Start date Start date
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?
 
Change the format of B1 to general (it's probably set to text at this time)
 
It's set to general already. Totally confusing



Michael Hopwood said:
Change the format of B1 to general (it's probably set to text at this time)
Click to expand...
 
Sherry

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

Gord Dibben XL2002
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concantenate which keeps bold of some parts. 5
Format of cell 1
Format of cell 1
Help with formula 4
copy and paste the cell with formula ="1" 3
Please help with countif formula 4
Scrabble Value calculation for Welsh words 0
Count between dates with some entries marked as "-" 5

Back
Top