[PHPExcel] Format cell as date (Germany)

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


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


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 .