I'm using Excel 2010, and whenever I type a text that starts with an apostrophe ('), it is hidden. I can bypass this by adding a space at the beginning, but it's annoying and also ruins the structure of the text.
Is there a way to avoid this and have the apostrophe show?