I wrote a macro which takes an xls file and creates a csv file.
everything is working fine. one problem i am having the date needs to be in dd/mm/yy format. i translate it to that format i even msgbox the value and it is correct. However when i display it in excel in the csv file it comes out as d/mm/yyyy format. I opened the csv in a text editor and it shows the date correctly. why is excel messing around with the date???
any help with this would be appreciated.
THANKS.