Cell shows formula eg ='Sheet21'!F3 instead of result

G

Guest

I have a problem where when I insert a formula such as ='Sheet21'!F3, the
cell shows the formula, instead of the result. This isn't consistent
apparently. I have managed to copy the formula from another cell that works,
but when I then change the cell ref (e.g F3 to F4 in the above example), the
cell displays the formula again, instead of the result. Cell format is
"Text". Is this a cell formatting issue??
 
N

Niek Otten

<Is this a cell formatting issue??>

Yes. Format as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a problem where when I insert a formula such as ='Sheet21'!F3, the
| cell shows the formula, instead of the result. This isn't consistent
| apparently. I have managed to copy the formula from another cell that works,
| but when I then change the cell ref (e.g F3 to F4 in the above example), the
| cell displays the formula again, instead of the result. Cell format is
| "Text". Is this a cell formatting issue??
 

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

Why does forumula show in cell instead of formula result? 2
cell references-Please Help! Please Help! 4
Formula result not displaying in cell 3
Cell shows the last typed text, no matter where it is typed 0
Nested formula using WORKDAY function 5
Creation of a formula 2
cell displays 0 when formula is valid 2
Count Cells Within 10 of a Cell Value 2

Top