How To Display A Single Quote In A Cell In Excel

In this Excel lesson you will teach yourself how to deal with single quote issues.

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.

mytext single quotation problem

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

Template

You can download the Template here – Download