![]() |
formula does not display the resulting value in the cell
I have a correct formula, but instead of getting the result displayed, I get
the formula. |
formula does not display the resulting value in the cell
Change the format in the cell with the formula to either general or a
number, press F2 and enter -- Regards, Peo Sjoblom "Liliana" wrote in message ... I have a correct formula, but instead of getting the result displayed, I get the formula. |
formula does not display the resulting value in the cell
Also check ToolsOptionsView and make sure that the Formulas box is
unchecked. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Peo Sjoblom" wrote in message ... Change the format in the cell with the formula to either general or a number, press F2 and enter -- Regards, Peo Sjoblom "Liliana" wrote in message ... I have a correct formula, but instead of getting the result displayed, I get the formula. |
All times are GMT +1. The time now is 05:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com