value not recognized as a formula

M

Michelle

I have a worksheet with a set a cells that will not recognize the values I
enter as formulas. I enter the same type formula as I have throughout the
sheet and the value I enter appears in the cell. I want this particular set
of cells to show the value from another cell on the sheet. The formula is
=B7, but this shows up in the cell instead of being read as a formula. I
tested this by entering =2+2 in the formula bar and the value appeared in the
cell as =2+2.

Thank you,
Michelle Gutierrez
 
E

Eduardo

Hi Michelle,
If you are using excel 2007 go to the menu to Formulas and then under
Formula Auditing, click in show formulas
 

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

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Excel Formula question 0
Formatting question: how to format duration (time spent)? 0
Would like to input 3 letters into a cell, each having a different numerical value 5
Drop down list control value in vba 2
custom data validation on cells with data validation values 2
VLOOKUP & Data Validation 0
trouble with (complicated) vlookup searching another workbook 2

Top