December 29, 2016
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...
June 25, 2016
There could be two reasons.
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.
Format the affected cells as GENERAL and reenter the formulas.
If it is happening to the entire worksheet then maybe Excel is set to view Formulas instead of values.
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.
April 21, 2015
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas