|
Featured Tutorial
Featured Macro
Excel Magic Trick #210: Formula Not Calculating Stuck
If your formula does not calculate and is showing the equal sign and the rest of the formula without calculating, here are two possible solutions.
Formula "Stuck" Showing (Not Calculating)
If the formula still shows it could be two things:
1) You are in "Show Formula " mode; to get out of "Show Formula " mode, use the keyboard shortcut Ctrl + ~ (~ is to the left of the number 1 key).
2) The cell has the Number Format "Text". To get rid of "Text" format, open the Format Cells dialog box (Ctrl + 1), select a different format, click OK, hit the F2 key to put the cell into Edit mode and then hit enter.
Formula "Stuck" Showing (Not Calculating)
If the formula still shows it could be two things:
1) You are in "Show Formula " mode; to get out of "Show Formula " mode, use the keyboard shortcut Ctrl + ~ (~ is to the left of the number 1 key).
2) The cell has the Number Format "Text". To get rid of "Text" format, open the Format Cells dialog box (Ctrl + 1), select a different format, click OK, hit the F2 key to put the cell into Edit mode and then hit enter.