| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is Excel displaying the formula as text
It is probably because the cell is formatted as text. To get back the
formula, first format the text as general and then click on the cell then in the formula bar and press enter. "Richard" wrote: This isnt the situation where the formula versus value is being shown. This is a situation where it thinks the formula is a text value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula structure building ? check under the excel forum.... | Excel Discussion (Misc queries) | |||
| Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Can I create an IF formula for single cell w/ dif. text in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
