Export string to excel (and stays string)

[Marco]

Hello,

I can not find any solutions for the next problem.

In my datagrid i have a column with values like 001, 002, 003, etc..
The values must stay like they are, string values. (all the other data in the column is also string.)
When i export to excel the values become 1, 2, 3, etc..

My question is, how can i managed to let the values stay strings, when i export to excel.

[Princy]

Hi,

You can try wrapping the cell contents with   tags as suggested in the following forum link.
Leading Zero's - Export to Excel

Thanks
Princy.

[Marco]

Hello,

I have tried that, but then i get a (unwanted) space character, in front of the data.
(So the data to export is not equal anymore, with the real data)

I had a little hope  that there was a better way then this.

Thanks for the reply,
Marco