• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

Why does Excel not calculate my formula ?

Hi,

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 ?

Toco
0
Tocogroup
Asked:
Tocogroup
  • 2
  • 2
  • 2
  • +2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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
0
 
jppintoCommented:
Check on you Formulas tab, on Calculation Option to see if it's set to Automatic. Pressing F9 to calculate, does it calculate?
0
 
TocogroupAuthor Commented:
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 ?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Neil RussellTechnical Development LeadCommented:
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
0
 
jppintoCommented:
yes!
0
 
Neil RussellTechnical Development LeadCommented:
Ha looks like you spotted it while i typed it!
Yes thats correct thats why
0
 
Saqib Husain, SyedEngineerCommented:
press ctrl-~
0
 
TocogroupAuthor Commented:
Thanks for the confirmation.
Bit embarrassed about this one as I've never come across this before. Commonsense really.
Thanks again
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now