Single quotation mark in Excel not showing up

P

PALady

Typed single quotation mark ' in cell, and it doesn't show up on sheet. I
remembered that I needed to type two single quotes to have one show up in
cell, but I don't remember why. Can someone refresh my memory please. Thank
you!
 
G

Gary''s Student

A single apostrophe does not show up because Excel treats it as a Text marker
and not part of the text stream. Enter two apostrophes to get the single
quote in the text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Single Quotation mark in CSV 1
Excel CSV file: How to preserve double quotation mark on Unix ftp? 2
Put a single quotation mark in front of numbers in selected cells 4
Handling of Double or Single Quotation Marks in ConversationTopic 6
Single quotation mark prefix 5
Quote Marks Question 2
excel save as csv quotation mark 1
How to stop quotation mark autoformating to German umlauts 2

Top