Date format for Excel RTD

suntonphon

New Member
Joined
Aug 2, 2010
Messages
2
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.
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,950
Messages
5,508,327
Members
408,679
Latest member
Daven13

This Week's Hot Topics

Top