Let me save/close EXCEL if a formula I put in has an error in it

[Tony Borg]

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.
--
TonyB

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-c13d658ce11a&dg=microsoft.public.excel.setup

 

[Gord Dibben]

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