![]() ![]() ![]() If your cell is not formatted as text, then it is very possible that you are suffering from "fat-finger syndrome." (Well, that's what I call it when I inadvertently hit the wrong keys.) Check your formula to make sure that it starts with an equal sign and that it doesn't have any other prefatory characters, such as a space, an apostrophe, a comma, etc. ![]() The easiest way is to simply press F2 and immediately press Enter that should do it. After picking a different format, you'll need to "edit" the formula to force Excel to parse the formula as a formula. In the Number Format drop-down list, make sure that a format other than Text is selected. Select the problem cell and display the Home tab of the ribbon. The first thing to check is that the cell isn't formatted as text. There are a few possible reasons this may be happening. It doesn't happen all the time, but Steve finds it quite confusing when it does. Steve notes that there are a few times when adding a formula to a cell in an existing worksheet (one he's worked with for quite a while) Excel ends up displaying the formula he typed instead of the result of the formula. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |