May 10 2023 11:50 PM
Can anyone tell me why my worksheet allows me to type in formulas one minute but then suddenly starts to display the formulas as text and won't do the calculations?
May 10 2023 11:54 PM
There are a few possible reasons why Excel might be displaying formulas as text instead of calculating them:
If none of these solutions work, try restarting Excel or your computer. If the problem persists, there may be an issue with your Excel installation, and you may need to repair or reinstall Excel.
Hope it helps you!
May 11 2023 12:44 AM
@NikolinoDE Thank you the third of those options sounds the most likely in this case, though it think it seems to be toggling itself on and off???
Feb 20 2024 05:24 AM
@tbrien1985 I have been experiencing exactly this and it's driving me mad! I have tried all the noted resolutions but still happening and even shutdown and rebooted laptop but this issue won't go away!
Mar 19 2024 06:15 AM
I was frustrated yesteday. Finally, I recreated a new column, and then followed instructions. And results showed. I then deleted the original columns