For some reason every time I Transer a date stored in a variable over to Excel, it changes the date around but keeps the dd/mm/yyyy, for example, 3rd of october 2004 would send from vb as 03/10/2004, but in excel will display as 10th march 2004 10/03/2004. Is this a known issue? can it be solved? any help would be much apprieciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VB to Excel Date Transfer
- Thread starter OC2
- Start date
- Status
