Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this community
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?
The apostrophe ' is a special character for Excel when it appears as the first character in a cell. It tells Excel to treat the rest of the string as text.
So, you want to know how to bypass this? The solution is pretty straight forward.
Just type two apostrophes. Yes, you heard it right. Instead of ' type ''. Remember, not a double quote, just two single quotes and you will have it in the cell. See this:
C:\\Users\\Eran.
Apr 7, 2020 at 16:18
The other way to force a string to be treated as a string
(e.g., not as a number) is to enclose it in double quotes
and put an equal sign in front.
So, to get 123 as a string, you can type '123 or ="123",
and to get '123 (as a string), you can type ''123 or ="'123".
