Hi all,
Sometimes when I try to do a formula in Excel, instead of appear value, appear formula.... Why this happen?
Eg: Sheet Lápis I link in A2 = LapisA2 and instead of appear value 8 appear =LapisA2.
Can you help me? I don´t have spaces in blank...
Thanks
Hi Hava
There could be two reasons.
Reason 1
If it is happening to only one or two cells then it is likely those cells are formatted as TEXT. If any cell is formatted as TEXT, any formulas entered in them will appear as text and not as a formula.
Solution
Format the affected cells as GENERAL and reenter the formulas.
Reason 2
If it is happening to the entire worksheet then maybe Excel is set to view Formulas instead of values.
Solution
From the Ribbon select Formulas-Show Formulas to toggle between Values and Formulas display. You can also press the ALT+~ key to toggle between the two displays.
Hope this helps.
Sunny
Sorry, doesn't see an attachment?
Hi All,
Yes I don´t any attachment. Thanks
