Date Format

[Jez]

Hi,

I work for a computer software company. We export data to Excel. We have a
client in South Africa where the date is getting muddled when it is exported
to Excel.

For example, if the date read 19/11/2009, when exported to Excel it would
read 2019/11/09 (as though it is changing the format from DD/MM/YYYY ti
YYDD/MM/YY.

I have tried changing the Regional settings and the language/date formats in
Excel but this does not seem to rectify the issue.

Has anybody ever experienced this before? Any help would be gratefully
recieved.

(Just to confirm, this is not an issue for any other customer -
English/American/German etc)

 

[Dave Peterson]

I don't have a guess--but just a question or two...

Are you sure you're passing a 4 digit year to the recipient?

How are you sharing the information (as a .txt file, a .csv file, ...)?

How is the recipient importing the file into excel?

If you're doing all the work--and sharing an excel file.

Find your copy of the offending workbook. Open it. And try changing the date
format for one of the offending cells to an unambiguous date format (like mmmm
dd, yyyy). I bet your data doesn't represent the dates you want.