[PHPExcel] Format cell as date (Germany)

Topics: Developer Forum, User Forum
Jul 19, 2011 at 8:09 AM

Hello,

I write data with PHPExcel into an Excelsheet. If it is a date I'm formatting it as described behind those links:

http://phpexcel.codeplex.com/discussions/244227
http://stackoverflow.com/questions/3...r-double-click

This way the date will be written into cell in correct format.
But if I right click the cell in Excel and choose "cell format", there is "user defined" highlighted and not "date".

How to set the formatting to date?

PS: I'm using a german MS Office 2003 .

 

thx