Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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
2  
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .