| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell displays Formula text
Can anyone explain why cell will display the "text of a formula" instead of
the formula results? I have checked to confirm that the cell is not forced text (no ' beginning value. When I edit the cell, Excel recognizes that the cell contains a formula and returns the expected result. The function of the formula does not seem to part of the issue. I have received this strange situation with the 'sum' and 'left' functions. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell displays Formula text
Hi
Try ToolsOptionsView uncheck formulas -- Regards Roger Govier "intellbus" wrote in message ... Can anyone explain why cell will display the "text of a formula" instead of the formula results? I have checked to confirm that the cell is not forced text (no ' beginning value. When I edit the cell, Excel recognizes that the cell contains a formula and returns the expected result. The function of the formula does not seem to part of the issue. I have received this strange situation with the 'sum' and 'left' functions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A cell displays many ###'s instead of the text data. | Excel Discussion (Misc queries) | |||
| formula displays, not the text | Excel Worksheet Functions | |||
| Text displays as ### in a cell. | Excel Worksheet Functions | |||
| Copy formula so destination displays formula as text | Excel Discussion (Misc queries) | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Linear Mode
