Excel Mac Big Sur seems to have corrupted formulas. Try entering formulas and they won't calculate. Appear as formula, not result. Checked for characters, changed format to numbers etc. Nothing works!!!
Very frustrating
After changing the cell format, click on cell to edit and hit return. It doesn’t automatically recalculate (at least that is what I’ve seen on the Windows version).
After changing the cell format, click on cell to edit and hit return. It doesn’t automatically recalculate (at least that is what I’ve seen on the Windows version).
Probably best to ask in the excel forum
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac
Excel Mac Big Sur corrupted formula
