Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Cell Showing Formula, not Result

Cell Showing Formula, not Result

Cell Showing Formula, not Result

I have a small question:
In a worksheet that prepared by others, I want to put a formula in a cell. But when I put there, I see just formula and not result of formula?!
To let you know,other part of worksheet is only Text.


RE: Cell Showing Formula, not Result

Have you tried to reformat the cell as "General" or "Number?"


RE: Cell Showing Formula, not Result

You may also want to make sure there is an "=" sign leading off the equation.

RE: Cell Showing Formula, not Result

Thanks for your replies.
Yes, there is = ahead of formula.
I changed cell property to number.
But they didn't work!

RE: Cell Showing Formula, not Result

Check under Tools|Options|View|Window Options and make sure Formulas is not checked, because that will always show formulas.

RE: Cell Showing Formula, not Result

Is it really a formula?  Or is it text that just looks like a formula?

RE: Cell Showing Formula, not Result

Your problem must be that the cell was originally formatted as Text, so it just displays exactly what was typed into it, even a formula (like "=A1+B1").  You have been given half of the answer in a previous response; make sure you change the format of the cell(s) to General.  However, after doing that, you must then select the cell(s) and use the Excel Edit|Replace function to replace all the "=" with "="; this will force the cells to recalculate and the formala(e) will work!



RE: Cell Showing Formula, not Result

Also, check the cell in question.  Click on the cell and look at the contents in the typing line near the top of the screen.  If there is an apostrophe before the = sign, delete it.  The apostrophe sign makes the formula a text entry.

For example, entering =2+3 will show 5 but entering '=2+3 will show =2+3

RE: Cell Showing Formula, not Result

another thing you can try, if all cells are showing formulas instead of results:  hit ctrl-`  (same key as ~).

RE: Cell Showing Formula, not Result

Thank you guys
You solved my problem.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close