I am working in Excel 2016 for the Mac, version 16.20, build 181208. I am experiencing frequent problems with formulas, or partial formulas, appearing in cells instead of the results. This does not happen in all cells on the affected workbook, or on all workbooks. I have checked the cell format and it is not text, and is the same for cells that do not have problems. "Edit directly in Cells" is not checked. See cell V4. Cell U4 has a formula but shows results correctly.. Help!

I may have jumped the gun a little. 16.21 should be available within hours.

Formulas Appearing in Cell Instead of Result - EXCEL 2016 for Mac

Anonymous

I am working in Excel 2016 for the Mac, version 16.20, build 181208.

I am experiencing frequent problems with formulas, or partial formulas, appearing in cells instead of the results.

This does not happen in all cells on the affected workbook, or on all workbooks.
I have checked the cell format and it is not text, and is the same for cells that do not have problems.
"Edit directly in Cells" is not checked.

See cell V4. Cell U4 has a formula but shows results correctly..

Help!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

11 answers

Anonymous

2019-01-15T17:11:00+00:00

I may have jumped the gun a little. 16.21 should be available within hours.
Please sign in to rate this answer.

0 comments No comments

Share via

Formulas Appearing in Cell Instead of Result - EXCEL 2016 for Mac

11 answers