' syntax to replace single quote mark
I have an entire spreadsheet that uses a single quote mark about 1000 times. When I opened the document this morning, all the single quote marks had been replaced by ' in the spreadsheet. The formula bar reflects the correct single quote and does not reflect the ' syntax. It's only this way in the body of the spreadsheet.
I'm hoping for a simple find all / replace all command that I might be able to use. Not to mention that there seems to be a bug - i won't be using the single quote any longer on Zoho :(
Anyway that I can get rid of this syntax? I've tried copying/pasting to another Excel spreadsheet but it only copies unicode text (and didn't capture the entire spreadsheet anyway). Help!!
Mac 10.6.8
Firefox 6.0