You may have set the cell formatting to “Text” and then typed the formula in it. To fix this error and get back the values (or results) just press CTRL+` again or click on the “Show formulas button” The next reason why formulas are shown as formulas: When you do it, excel shows the formulas instead of their results. You may have accidentally pressed CTRL+` (back quote symbol, the key below escape key in your keyboard) or activated the “Show Formulas” mode in Excel. The top reason for Excel formula showing as text : So instead lets roll up our sleeves and find out the reason for this mishap. But careful donuts sure sounds like a paradox. Of course, you can be careful when eating donuts. Excel formula showing as text instead of actual result, like this: You check if a donut chunk went in to the key board and some how jammed the ENTER key. You type a formula in a cell, then you press ENTER. Once in a while everyone is bound to come across this problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |