Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Divison formula not providing answer.
I recently got Excel 2007 @ work. When I type =D12/2 in the cell I expect to
see the answer (whatever D12 is divided by 2). What I get is =D12/2. That happens whether I type in the cell name or I click on the cell. Is there a different way to type formulas in 2007 vs. 2003, or am I doing it wrong, or what? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Divison formula not providing answer.
The cell was formatted as text before you entered the formula. Just
reformatting is not enough; Format as number AND re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "EKNelson" wrote in message ... I recently got Excel 2007 @ work. When I type =D12/2 in the cell I expect to see the answer (whatever D12 is divided by 2). What I get is =D12/2. That happens whether I type in the cell name or I click on the cell. Is there a different way to type formulas in 2007 vs. 2003, or am I doing it wrong, or what? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Divison formula not providing answer.
There is no difference in formula entry. You have one of two possible
problems. 1) The cell is formatted as text and thus not recognizing the formula. Try changing the format and see if thsi fixes the problem. 2) Your options are set to display formula in cell rather than the results. If 1 did not fix the problem, this is the next msot likely cause. To check the settings go to the Office button (top left), click the excel options button on the bottom. Select Advanced on the left and scroll down to the Display Options for this Worksheet section. If the "Show formulas in cells instead of thier calculated results" box is checked, uncheck it and then click OK. -- If this helps, please remember to click yes. "EKNelson" wrote: I recently got Excel 2007 @ work. When I type =D12/2 in the cell I expect to see the answer (whatever D12 is divided by 2). What I get is =D12/2. That happens whether I type in the cell name or I click on the cell. Is there a different way to type formulas in 2007 vs. 2003, or am I doing it wrong, or what? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Divison formula not providing answer.
Hi,
In the main menu go to Formulas and in Formula Auditing, click in show formulas "EKNelson" wrote: I recently got Excel 2007 @ work. When I type =D12/2 in the cell I expect to see the answer (whatever D12 is divided by 2). What I get is =D12/2. That happens whether I type in the cell name or I click on the cell. Is there a different way to type formulas in 2007 vs. 2003, or am I doing it wrong, or what? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Divison formula not providing answer.
Thanks! This was a simple and correct answer to my problem!
"Niek Otten" wrote: The cell was formatted as text before you entered the formula. Just reformatting is not enough; Format as number AND re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "EKNelson" wrote in message ... I recently got Excel 2007 @ work. When I type =D12/2 in the cell I expect to see the answer (whatever D12 is divided by 2). What I get is =D12/2. That happens whether I type in the cell name or I click on the cell. Is there a different way to type formulas in 2007 vs. 2003, or am I doing it wrong, or what? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Divison formula not providing answer.
Thank you! This correct answer gave me a couple of options, which I appreciate.
"Paul C" wrote: There is no difference in formula entry. You have one of two possible problems. 1) The cell is formatted as text and thus not recognizing the formula. Try changing the format and see if thsi fixes the problem. 2) Your options are set to display formula in cell rather than the results. If 1 did not fix the problem, this is the next msot likely cause. To check the settings go to the Office button (top left), click the excel options button on the bottom. Select Advanced on the left and scroll down to the Display Options for this Worksheet section. If the "Show formulas in cells instead of thier calculated results" box is checked, uncheck it and then click OK. -- If this helps, please remember to click yes. "EKNelson" wrote: I recently got Excel 2007 @ work. When I type =D12/2 in the cell I expect to see the answer (whatever D12 is divided by 2). What I get is =D12/2. That happens whether I type in the cell name or I click on the cell. Is there a different way to type formulas in 2007 vs. 2003, or am I doing it wrong, or what? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Divison formula not providing answer.
Thanks for answering! Even though my problem was of a more obvious nature, I
appriciate a fast answer with additional thigs to try! "Eduardo" wrote: Hi, In the main menu go to Formulas and in Formula Auditing, click in show formulas "EKNelson" wrote: I recently got Excel 2007 @ work. When I type =D12/2 in the cell I expect to see the answer (whatever D12 is divided by 2). What I get is =D12/2. That happens whether I type in the cell name or I click on the cell. Is there a different way to type formulas in 2007 vs. 2003, or am I doing it wrong, or what? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Divison as a formula | Excel Discussion (Misc queries) | |||
Formula or Function providing Mile value in a cell from 2 addresse | Excel Worksheet Functions | |||
ERRORS IN A DIVISON FORMULA | Excel Discussion (Misc queries) | |||
symbol for divison problems; divison formula | Excel Discussion (Misc queries) | |||
There may be a simple answer ... | Excel Discussion (Misc queries) |