| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why does Excel show a formula in ONE cell ?
Excel is showing me a formula in just one cell on my spreadsheet, instead of
the formula result. I know the formula's correct (didn't forget to start with "="). How do I turn off the formula and turn on the result? Other adjacent cells are showing results rather than formulas. I can't find any format switch that would do this, and nothing in HELP. |
|
#2
|
|||
|
|||
|
Ed,
The formula can show if the cell is formatted for text (Format - Cells - Number tab). Make sure it's a format other than text. Then press F2 (edit) then Enter. -- Earl Kiosterud www.smokeylake.com "edpaul" wrote in message ... Excel is showing me a formula in just one cell on my spreadsheet, instead of the formula result. I know the formula's correct (didn't forget to start with "="). How do I turn off the formula and turn on the result? Other adjacent cells are showing results rather than formulas. I can't find any format switch that would do this, and nothing in HELP. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lock a formula in a cell in an Excel worksheet? | Excel Discussion (Misc queries) | |||
| 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 | |||
| how do I show a picture in excel based on cell data | Excel Discussion (Misc queries) | |||
| how do i create a blank cell in excel using a formula | Excel Worksheet Functions | |||
Linear Mode
