Excel Single Quote Display in Cell: Text Handling

How To Display A Single Quote In A Cell In Excel

In Excel there is a problem that ‘yourtext’ (text inside single quotes) displays without leading single quote. There is an easy way to deal with this issue.

1. Right click your cell.
2. Choose Format Cells to format a data type for the cell.
3. Click Custom Category.
4. Write down ‘@ (single quote and at) as a type.

That’s it. Your single quotes are displaying correctly since now.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References