Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula entry in Excel
Why, occasionally, when I enter a formula into a cell, I get the formula
displayed rather than the result? |
#2
|
|||
|
|||
Are you making sure there is a = sign in front of the formula?
"David Boas" wrote: Why, occasionally, when I enter a formula into a cell, I get the formula displayed rather than the result? |
#3
|
|||
|
|||
If the cell was formatted as Text (format|Cells|number tab), then your formula
is just a text value. If you start your formula with " =..." (Spacebar, equals), then excel will see it as text. David Boas wrote: Why, occasionally, when I enter a formula into a cell, I get the formula displayed rather than the result? -- Dave Peterson |
#4
|
|||
|
|||
Most likely the cell is set to text. Thus anything you enter will be
interpreted as text, including a formula. This can happen if you insert a new column between columns, and the column to the left of the inserted column is text. HTH Jason Atlanta, GA "David Boas" wrote: Why, occasionally, when I enter a formula into a cell, I get the formula displayed rather than the result? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
excel formula | Excel Discussion (Misc queries) | |||
How do i make journal entry in excel? | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |