| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
function displaying in an Excel cell instead of the answer
When I type in valid functions and hit "enter," the cell displays the formula
instead of the answer. How can I get it to display the answer instead?? |
|
#2
|
|||
|
|||
|
function displaying in an Excel cell instead of the answer
make sure the number format for that cell is not text (General??).
Make sure you start your formula with an equal sign. Make sure you're not looking at formulas: tools|options|view tab|uncheck Formulas (if it's checked) Edwin Grosvenor wrote: When I type in valid functions and hit "enter," the cell displays the formula instead of the answer. How can I get it to display the answer instead?? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Finding a function in Excel | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Hybrid Mode
