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?

2 Answers

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:

7

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".

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy