Excel 2016
In some columns, cells show the formula, in other columns, the result of the formula is shown. I have formulas in a new sheet that simply refer to another sheet in the same workbook, called "OriginalData".
It happened when I manually changed the row in the reference formulas from row 4 to row 3 to adjust for a mistake. Before that, this problem did not occur. It happens in one column that refers to a date, and in one column that refers to free text. In other columns with free text and those with a date, the content is shown as it should. If I type any other formula, like =1+1 in a buggy cell, it shows "=1+1" rather than the result "2". The format of the buggy F-column is Date.Please Login or Register to view this content.
I've tried to force calculation with shift+F9 and to close and restart Excel, to no avail.
What can I do to fix this, and to avoid having it happen again?
Bookmarks