show apostrophe / single quote in cell
start your text with a pair of single quotes and it your text with one single
quote.
--
Gary''s Student - gsnu200767
"Beans" wrote:
Is is possible to have excel show an apostrophe / single quote in cell. I
know you can use it to force text, however, I would like the character to
display in the cell.
Ex. Cell displays Hg and I would like it to display 'Hg'
Thanks,
Chad
|