View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michelle michelle is offline
external usenet poster
 
Posts: 310
Default value not recognized as a formula

Thanks for your reply, I forgot to state I am using 2003.

"Eduardo" wrote:

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



"Michelle" wrote:

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