When Excel refuses to take the formula and tells you something is wrong
acknowledge and hit OK then.............

Click in the formula bar and place an apostrophe left of the = sign.

This will turn the formula to a text string for later editing.


Gord Dibben MS Excel MVP

On Fri, 1 Sep 2006 18:21:01 -0700, Tony Borg
wrote:

Sometimes if I enter a formula in EXCEL and it has an error in it e.g.
incorrect syntax etc. I get frustrated especially if its a long formula and I
do not have the time at that moment to find out where the error is. To save
any other changes I have made, I have to delete the formula. I would like to
save the workbook with the incorrect formula intact so I can return to it and
fix it at a later date.