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.


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell