| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas are displayed in Excel instead of the data
Occasionally when I type in a formula in Excel, instead of getting the
results, the formula just shows up instead. As an example, if I type "=$A$2" and hit enter, instead of getting the contents of what is in cell A2, I just see the formula "=$A$2" instead. I do not understand what causes this to happen and have not been able to find anything in the help files. Thanks, -- Perry K |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas are displayed in Excel instead of the data
The cells you are typing into are formatted as text. select the cells,
go to Format - Cells select General (or any non-text format) Enter your formula and it should work. if it doesn't, try this... 1) enter your formula 2) click on the cell containing the formula, go to format - cells - select General (or any non-text format) 3) double click on your formula to edit it and hit enter. On Jun 20, 8:37 am, PerryK wrote: Occasionally when I type in a formula in Excel, instead of getting the results, the formula just shows up instead. As an example, if I type "=$A$2" and hit enter, instead of getting the contents of what is in cell A2, I just see the formula "=$A$2" instead. I do not understand what causes this to happen and have not been able to find anything in the help files. Thanks, -- Perry K |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas are displayed in Excel instead of the data
That fixed it.
Thanks, -- Perry K "Tim879" wrote: The cells you are typing into are formatted as text. select the cells, go to Format - Cells select General (or any non-text format) Enter your formula and it should work. if it doesn't, try this... 1) enter your formula 2) click on the cell containing the formula, go to format - cells - select General (or any non-text format) 3) double click on your formula to edit it and hit enter. On Jun 20, 8:37 am, PerryK wrote: Occasionally when I type in a formula in Excel, instead of getting the results, the formula just shows up instead. As an example, if I type "=$A$2" and hit enter, instead of getting the contents of what is in cell A2, I just see the formula "=$A$2" instead. I do not understand what causes this to happen and have not been able to find anything in the help files. Thanks, -- Perry K |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas displayed in all of my cells | Excel Worksheet Functions | |||
| Formulas Are Displayed and are not calculating | Excel Discussion (Misc queries) | |||
| I've changed the way my formulas are displayed !! | Excel Worksheet Functions | |||
| format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
| Automatic linewrap with formulas displayed | Excel Worksheet Functions | |||
Linear Mode
