On Tue, 08 May 2007 12:38:01 -0400, Ron Rosenfeld
wrote:

That symbol is merely a text marker -- it marks the contents of the cell as
being text.

It could also be a Lotus left-justified label marker if the transition
navigation keys option is checked.

Excel apparently puts a leading single quote in text cells when populated from
SQL (and perhaps from other sources). But the character doesn't print, and
shouldn't affect anything other than signifying that the data is textual.

It can be removed by several methods.

What is the data like? (i.e. is it numeric to be treated as numeric?, text to
be treated as text? numeric to be treated as text?, etc)?






Also, if it is a number, is the number more than 15 digits long?
--ron