Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
We use a macro to export a table in Excel.
the table contains dates, when we open the file with Excel in US version the dates are correct, in the right format DD/MM/YYYY but when we open it in Frensh version, the dates with day < 13 are changed to MM/DD/YYYY (wrong!).
I found in the internet that the month/day inversion of a date is a recurring problem in VBA but I can't find a solution (Défaut de date US / FR dans un macro (excel-pratique.com) ).
I tried to putting Date(field, "DD/MM/YYYY") on script and also on table properties but no success at all.
Could you please help me to solve this issue?
Thank you in advance.
could you please help me to solve this issue?