17
3
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?
Try the following: click Format, Cell and select the Number tab. If the type is Text, change it to Number. – LDC3 – 2014-09-13T13:54:38.830
I will but it doesn't answer the question of why it suddenly went wrong :) – Mr. Boy – 2014-09-13T13:55:38.610
Most likely you got a space or some other character inserted ahead of the = sign in the field. It's easy to happen. – Tyson – 2014-09-13T13:59:26.980
1Read the question... ALL I am doing is double clicking a cell and hitting enter. I did this on like 10 cells and the same thing is happening... I'm NOT modifying the formula. – Mr. Boy – 2014-09-13T14:09:47.103
1If you have
@
in your custom number format, Excel will sometimes incorrectly show the formula rather than the value – airstrike – 2016-11-30T21:57:24.617