what does a single quoatation mark appear in text cells

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
..
"Stache02" wrote in message
...
what does a single quoatation mark appear in text cells

is there a way to not show these characters in the text..

"Tyro" wrote:

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
..
"Stache02" wrote in message
...
what does a single quoatation mark appear in text cells

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

Tyro

"Stache02" wrote in message
...
is there a way to not show these characters in the text..

"Tyro" wrote:

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
..
"Stache02" wrote in message
...
what does a single quoatation mark appear in text cells

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


On Fri, 11 Jan 2008 10:12:07 -0800, Stache02
wrote:

what does a single quoatation mark appear in text cells