Re: Remove apostrophe from text (export to Excel)

From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxx>
Date: Tue, 2 May 2006 15:10:43 +0100

Edwin wrote on Tue, 2 May 2006 15:14:33 +0200:

I know but how to get rid of it?

Why exactly do you need to get rid of it? For Excel it defines the cell as
text rather than general, when using ADO to read that data it should not
appear. Appearing in the Edit field is purely to define the data - it does
not affect the spread*** itself.

Dan

.

Follow-Ups:
- Re: Remove apostrophe from text (export to Excel)
  - From: Edwin Knoppert

References:
- Remove apostrophe from text (export to Excel)
  - From: Edwin Knoppert
- Re: Remove apostrophe from text (export to Excel)
  - From: Daniel Crichton
- Re: Remove apostrophe from text (export to Excel)
  - From: Edwin Knoppert

Prev by Date: Re: Remove apostrophe from text (export to Excel)
Next by Date: Re: Slow access on XP using ADO with ODBC to SQL Server 2000 - any ideas?
Previous by thread: Re: Remove apostrophe from text (export to Excel)
Next by thread: Re: Remove apostrophe from text (export to Excel)
Index(es):
- Date
- Thread