How to properly display single quotes in Excel

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 325
Joined: Tue Sep 25, 2007 12:41 pm

How to properly display single quotes in Excel

Post by Admin »

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.


Image



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.


Image



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


Image



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 :-)
Post Reply