Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to properly display single quotes in Excel

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 272

PostPosted: Tue Feb 21, 2017 1:22 pm    Post subject: How to properly display single quotes in Excel Reply with quote

In Excel if you type any text within double quotes, it displays properly (like "John Donlee"), but in case of single quotes, it displays without the leading single quote. So if you type 'John Donlee', it displays John Donlee' as in the image below.






What you need, is to customize your cell format.

Right mouse click on the cell > click on Format Cells...

Format Cells window opens. Here from under Category click on Custom.

Under Type: enter '@ > click OK.






Now type anything using the single quotes, it will display your entries properly.






In case, if you need a whole colum full of entries within single quotes, then right click on the column heading, go to Format cells... and do customise as above.


Have fun Smile





*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group