Datatype changes when exporting to Excel

Martin · Post by **Martin** » Tue May 06, 2014 5:45 am

Hi,
When I export some adresses to an excelsheet, the housenumbers (original datatype = varchar(255) ), the datatype of the housenumbers sometimes changes to datetime type.
For example : Dorpsstraat 4-6 will be exported as Dorpsstraat 4-jun
What can I do to achieve a correct exportfile?
Thanks, Martin.

mobhar · Post by **mobhar** » Tue May 06, 2014 10:56 am

Did you use "PHPExcel" extension?

Martin · Post by **Martin** » Mon May 12, 2014 6:19 am

Thanks Mobhar, this was were it went wrong.
Great help, problem solved.