In my program I pass values from VB to Excel for reporting.
When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009.
I have set short date format to dd-mm-yyyy, in control panel, regional settings.
Also in excel, I set cell format through VB as ...
Exl.Range("A1").NumberFormat = "dd-mm-yyyy"
Exl.Range(Rng).NumberFormat = "@"
Exl.Range(Rng).NumberFormat = "dd-mm-yyyy;@"
But neither of way works, it shows 01-03-2009
Please give me the solution to this problem.