what is single quotation mark left side of cell for

  • Thread starter Thread starter Stache02
  • Start date Start date
The single quote tells Excel that what follows is text. For example if you
enter: 123, that is the number 123 and will be right justified. If you
enter '123. That is text amd will be left justified. However, you can still
use the text '123 in computations.

Tyro
..
 
The single apostrophe shows only in the formula bar not in the cell.

Tyro
 
The single quote mark you see in the formula bar denotes the cell is formatted
as text.

The quote mark should not be showing up in the cell or when printing out.

If you have a quote mark showing in the cell, you have entered it by adding two
quote marks and you should two in the formula bar.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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
Quote Marks Question 2
Single quotation mark in Excel not showing up 1
What does "" mean in Excel? 2
without quotation marks? 1
Generating text surrounded by quotation marks 5
Quotation Marks as Text 2
How to stop Excel adding quotation marks when copying to notepad? 3

Back
Top