Why does Excel not calculate my formula ?

Posted on 2011-05-04
Last Modified: 2012-05-11

I have an Excel 2007 worksheet which ignores the formulas I enter, even simple ones like =SUM(6,10). It just displays the formula as if it's text.

The Calculation Options are set to Automatic but even a Manual calculation makes no difference. How can this happen ?

Question by:Tocogroup
    LVL 50

    Expert Comment


    One possiibility:

    Is your workbook showing Formulas instead of values? Hold down the Ctrl key and hit the ~ sign (the key to the left of the 1 on a US keyboard) to toggle between the views.

    cheers, teylyn
    LVL 33

    Expert Comment

    Check on you Formulas tab, on Calculation Option to see if it's set to Automatic. Pressing F9 to calculate, does it calculate?

    Author Comment

    Actually Teylyn I think it's more basic than that.

    If the format of the cell is text, will it ignore the = sign as a formula symbol ?
    LVL 37

    Expert Comment

    Most likely the cells are formatted as TEXT

    IF cells are formatted as text and THEN you enter a string like =9*8

    It will show =9*8

    Format cells as general
    LVL 33

    Expert Comment

    LVL 37

    Accepted Solution

    Ha looks like you spotted it while i typed it!
    Yes thats correct thats why
    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    press ctrl-~

    Author Closing Comment

    Thanks for the confirmation.
    Bit embarrassed about this one as I've never come across this before. Commonsense really.
    Thanks again

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now