Try Ctrl+` (which is the tilde key next to the #1 at the top). That
key combination toggles your view from formulas to values.
Nigel wrote:
I have a spreadsheet and am running so code across the sheet, all of a sudden
instead of applying the code it is now just putting the formulas in the
cells, I know a setting has changed somewhere but I can't find it

Any suggestions

THanks