Hi folks,
I've got a really weird problem. From a C++Application I have to export data to excel using OLE (don't ask why, just take it as it is ;-)). I have to tell excel the format settings for each cell (using the numberformat-property). If a value is a date, things really start being strange. On a german windows with a german excel numberformat must be filled with "TT.MM.JJJJ" instead of "DD.MM.YYYY".

In the control-panel these placeholders are also localized. But if I call GetLocaleInfo() with the appropriate parameters, I always get format string with the english placeholders ("d", "m" and "y"). And as the software runs in a lot of countries I have quiet a problem with that behaviour ;-) What I want to know: Is there any chance to retrieve that localized date-format string of the control panel's country settings?
Any help is welcome...

Chabba