If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Formula
Hello,
I have typed a formula into the formula and it has been placed in the appropriate cell. Unfortunately it will nor show the result of the formula in the appropriate cell. The only way I can view the result of the formula is to click on: fx and a little box pops up with the result off the formula. All the times I have used excel the result is automatically placed in the appropriate and the formula is not shown unless I click on that cell. Is there some setting I need to change for this to happen? Adagio |
#2
|
|||
|
|||
Excel Formula
The most likely explanation is that the cell in question was formatted as
text before you tried to enter the formula. Format as text then re-enter the formula (F2 and enter). If it isn't that, check that you haven't set the option to View Formulas. [The latter would apply to all cells, so you'd see no results, only fomulae.] -- David Biddulph "Adagio" wrote in message ... Hello, I have typed a formula into the formula and it has been placed in the appropriate cell. Unfortunately it will nor show the result of the formula in the appropriate cell. The only way I can view the result of the formula is to click on: fx and a little box pops up with the result off the formula. All the times I have used excel the result is automatically placed in the appropriate and the formula is not shown unless I click on that cell. Is there some setting I need to change for this to happen? Adagio |
Thread Tools | |
Display Modes | |
|
|