Date format for Excel RTD

[suntonphon]

Hi All,

Basically in excel if I call excel api for setting my data into cell in excel sheet,Excel::Range.Value(). Excel do the format in a cell following my data type
e.g.
I have variant variable and set it's type to VT_DATE then send it as an argument to Excel::Range.Value(). In the destination cell showing dd/mm/yyyy.

I'm wondering that if I set value to excel by using RTD mechanism, the value is VT_DATE type. Excel cannot do the format date for me when the value was show in destination cell.

Does someone know whether it is a restriction in excel or not?
How can I sole this problem?

Thanks,


Thanks,
Padungsak S.