And if all the formulas show--but not the results, maybe you toggled:
Tools|options|View tab|uncheck formulas
this can be toggled by hitting ctrl-`
(control-backquote, to the left of the the 1/! on my USA keyboard)
Both the target cell a destination cell are formatted as general and unlocked.
I tried switching Formula auditing on/off, but nothing happens