Excel Forum
Similar Content
Hide Comments in Excel Completely - Even Indicators Will not Appear
Macro: Hide all comments in an Excel workbook. No indicators will be displayed and comments will ...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.





Got a Question? Ask it Here in the Forum.