Convert Text to Formula

[zhaimj]

I have a bunch of cells ( about 150 ) in which I converted the formulas to text by replacing = with '= . When I'm done with data manipulation, I tried to convert those text back to formula with replacing '= to =. However, excel does not recognize the ' in front of the = sign any more for some reason. I think I had same issue before, but could not remember how it's solved other than fix them one by one. Anyone happen to know how to do with it? Thanks.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[AlphaFrog]

Select the cells you want to convert
Select from the menu Data\ Text to Columns and click on Finish

 

[zhaimj]

Great! Thanks so much, AlphaFrog .

 

[AlphaFrog]

You're welcome.

If you added the leading single quote to stop the formulas from calculating, there is an option on the Options menu to switch between Automatic and Manual calculation mode that would do the same thing.

http://www.ehow.com/how_2248633_switch-manual-calculation-excel.html