Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Open Excel 2007 and put

' '

in a cell and it will show as


Why? / More importantly / annoyingly how do you stop it?

I set the format to TEXT. No change.

share|improve this question
up vote 3 down vote accepted

Excel uses the single quote at the start of a cell to indicate that what follows should be treated as text. If you want to have ' ' display you can enter '' '. If you are concerned with having the data ' ' display correctly I don't have a good answer for you without knowing more about your requirements. It is possible that if this applies to a column you could create a custom display format '@ that would cause it to display as you want.

share|improve this answer
It's just annoying to paste in 'Test' and have Test' show up. – NitroxDM Feb 17 '10 at 21:15
No dice with the format @. – NitroxDM Feb 17 '10 at 21:16
The custom display format needs to be a single quote followed by the at sign: '@, not just the at sign which passes through text. – Jason Aller Feb 17 '10 at 22:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.