Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi rajesh
Please can you attach to see what is the problem?
Regards