My functions are not running, ie I enter =SUM(E1,E2), and this is what
displays in the cell rather that the result. I have tried toggled the 'Show
Formulas' feature. The cell containing the formula is not a text field, but
general. I am getting no error messages, simply the formula as written rather
than the result.

What gives?