Re: Remove apostrophe from text (export to Excel)

Edwin wrote on Mon, 1 May 2006 17:46:53 +0200:

I have trouble exporting data to an Excel ***.
The *** is filled and all seems ok except the ordinary string data.
They all get an apostrophe (')

Like: 'MyName instead of MyName
It's only visible when i select the cell and if i edit the cell, this
symbol remains.
It's not visible in Open Office.

I'm using VWD ASP.NET v2.

Part of my create table statement:
CREATE TABLE [sheet1] (
[ID] NUMERIC
, [Voorletters] varchar(255)
);

The data IS inserted using double quotes, previoulsy it was added using
apostrophes but doesn not seem related.

Thanks!


An apostrophe at the beginning of a cell defines the data as text, which is
why it doesn't show up when you look at the spread*** but it is visible in
the edit field.

Dan


.