How do I display a single quote in a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I display a single quote in a cell that has a single quote as the
first character? Excel uses the single quote to format the cell so it
doesn't display.
 
Just type it twice. The first one will not be displayed, but the second one
will.

HTH,
Elkar
 

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

Quote Marks Question 2
show apostrophe / single quote in cell 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Word wrap with > 255 characters 2
removing a single space in a cell 4
How can I copy plain text from Excel to Notepad? 5
Format Excel cells for "all caps", with Office 07? 4
Controlling word wrap in a cell 2

Back
Top