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. |
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. |
All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com