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