Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

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.