Date Format issues when exporting to data to Excel

[#1]

Hi

I have an application where I have functionality to export my objects and data to Excel using a button. I am trying to export a table with Calendar dates and when I export them the date format is wrong. I am after the date format 'DD/MM/YYYY' but whenever I export data the format is DD/MMYYYY in some cases and then MM/DD/YYYY, exporting extra lines from what I wish to export.

Will I need to something in my macro so that whenever I export data the format is the correct date format?

Is this a user Excel issue?

Any ideas.

Thanks

[Anonymous]

Hi rajesh

Please can you attach to see what is the problem?

Regards