by acknak » Tue Oct 11, 2016 5:18 pm
Changing the cell format does NOT change what's stored in the cell.
However, the format can change how Calc interprets what you enter. If the cell format was set to text when the formula was entered, the entry will be taken as text instead of a working formula. Once the formula is stored as text, Calc will not change it if you later change the cell format.
Set the cell format to Number > General (the default format) THEN edit the formula (add a space at the end and delete it). When you finish editing and press Enter, Calc will now re-interpret the entry and it should take it as a working formula.
AOO4/LO5 • Linux • Fedora 23