Turn off Formulas?

[bvs3150]

I need to make a database of formulas in excel without the formulas actually calculating. An it has to stay as the true formula not just add a (space or comma). Please help anyone! Im more than willing to explain further.

 

[Michael M]

Hi and welcome to the Board.
Have you considered turning off the Automatic Calculation ?
That way the formulas will only work if F9 is pressed.
If you are using 2007....Home Button / Excel Options / Formulas / deselect automatic and uncheck recalculate.
Otherwise, I can't think of another method of achieving the desired result.

 

[T. Valko]

I need to make a database of formulas in excel without the formulas actually calculating. An it has to stay as the true formula not just add a (space or comma). Please help anyone! Im more than willing to explain further.

See if this helps:

http://j-walk.com/ss/excel/tips/tip37.htm

 

[Michael M]

Nice one Biff.
Might have to save that...even though I may never use it !!

 

[T. Valko]

Nice one Biff.
Might have to save that...even though I may never use it !!

You could have used it today!

 

[Michael M]

Doh...Oh, yeah !!