Formula shows up as text in cell

  • Thread starter Thread starter BK523
  • Start date Start date
B

BK523

When I type a formula in the formula bar, the cell displays the text of the
formula, not the result. What happened?
 
Hi
Clear that cell,reformat as "General" then retype your formula.
HTH
John
 
Hi,

Ensure that the cell is not formatted as text. Go to Format > Cells >
General. Another possibility could be that you have accidentally pressed
Ctrl+~. Press that combination again to exit the formula auditing mode.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
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

Cell shows the last typed text, no matter where it is typed 0
Why does forumula show in cell instead of formula result? 2
Excel VBA 1
formula displays as a formula, not as its result 1
Formulas displayed in cell rather than calculated values? 4
Array formula lock-up 1
Searching the formula (not the value) for a text string 1
count - but exclude counting cells with a formula 4

Back
Top