Formula error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a simple formula to grab the text from a cell in another worksheet (same workbook). Instead of getting the text, the following is displayed (which is the text of my formula, not the text in the cell it should be reading):
='amen shell'!c1
What am I doing wrong??
Thanks!
 
Your cell was probably formatted as Text when you entered your
formula. Change the format to General, click in the cell to edit,
then hit Enter.
 
Hi,

I have read the information in your post, and one thing I would check would
be to determine if the worksheet where the formula resides is in Formula
mode or Value mode. You can check this from the following setting:

Tools menu > Options > View tab > Formulas checkbox

Is this item checked or unchecked? If checked, try unchecking and clicking
Ok. If this corrects the behavior, it sounds like the sneet may be
currently in Formula mode (which displays formulas rather than the formula
results.)

Hope this helps!
 
Back
Top