Hi Chad,
Yes, it is possible to display an apostrophe/single quote in a cell in Excel. Here's how you can do it:
- Double-click on the cell where you want to display the apostrophe.
- Type the apostrophe/single quote character before the text you want to display. For example, type 'Hg instead of Hg.
- Press Enter to save the cell.
The apostrophe will now be displayed in the cell along with the text. If you want to display the apostrophe in a formula, you can use the
function. Here's an example:
- In a cell, type =TEXT("'Hg","General")
- Press Enter to save the cell.
The apostrophe will now be displayed in the cell along with the text.