Characters bad when exporting asp.net datagrid to excel

G

Goran Djuranovic

Hi all,
When I export data from asp.net datagrid to excel spreadsheet, characters
such as "é" become "é". It looks like excel doesn't know how to convert
these.

Anyone?

TIA
 
B

Balazs - ExcelForums.com

Two things to try

1.) check your region settings. If you are exporting a french (as a
example) datagrid, try and enable French keyboard settings in region
in the control panel

2.) as a backup, just do a search and replace after the import an
replace the bad characters with the good. Not very efficient but i
works

Good luc
 
Top