We have an existing spreadsheet that has been working fine. Today we double-clicked a cell, to edit the formula, but did not change anything (we tested on other cells to check). When hitting enter, or clicking another cell after getting the cell in edit-mode, the cell stopped showing the formula result and instead showed the formula.
e.g cell was showing "102". Double-click and it showed =100+2. Hit enter and it shows "=100+2".
We haven't changed workbook settings, so why would it start doing this and how can we fix it?
Best Answer
You have "Text"-type formatting chosen.
I believe this has a tendency to "leak over" if adjacent cells have it.
It is an automatic formatting option, but please don't ask me how to turn it off.
Select the cell you have trouble with, then press CTRL+1 (Menu: Format > Cells)
Select "General" (in Excel) or "Category: All, Format: General" (LibreOffice)
... in the dialog that appears.
NOTE: You need to re-edit the cell too... (select the cell, hit F2 and then hit ENTER)
To reset ALL CELLS click the rectangle upper left - above
[ 1 ]and left of[ A ]- then reset it the same way as above, the last step is a bit cumbersome :-I .