Steve, one thing you didn't specify: Where are you seeing these dates as dd/mm/yyyy? a) In the workbook before you export to a CSV? b) In the CSV after you've created it from Excel? Or c) in the application on the other side, after it reads the CSV?
OTPM gave you the solution for a), which is the reasonable assumption if we have to assume at all. I think it's right for b), too, though I haven't tried it to be sure. But if your problem is different, you gotta say so, 'cause it might make a difference.
|