Formating Cells - Countryspecific problem
Posted: Fri Dec 19, 2008 4:05 pm
Hi all,
I have an excel file which includes formatted Data. If I format a cell to Date, Excel writes as Format m/d/yy even I am in Germany and the order is dd.mm.yyyy. This way Excel Shows it.
BUT if I add Dates with the xlsReadWriteII4-Component and Format 'dd/mm/yyy' or 'DD.MM.YYYY' then the old dates switch into american format.
I found in the internet a good explanation, but it is in VBA and the variable is called NumberFormatLocal. How can I influence this value? Is there a coresponding variable in xlsReadWriteII4 ?
I would appreciate any kind of help very much.
Thank you
Lothar
I have an excel file which includes formatted Data. If I format a cell to Date, Excel writes as Format m/d/yy even I am in Germany and the order is dd.mm.yyyy. This way Excel Shows it.
BUT if I add Dates with the xlsReadWriteII4-Component and Format 'dd/mm/yyy' or 'DD.MM.YYYY' then the old dates switch into american format.
I found in the internet a good explanation, but it is in VBA and the variable is called NumberFormatLocal. How can I influence this value? Is there a coresponding variable in xlsReadWriteII4 ?
I would appreciate any kind of help very much.
Thank you
Lothar