Date format getting muddled

J

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 recitfy 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)
 
F

Fred Smith

It's not "changing the format", it's assuming your input is in yy/mm/dd
format. This is a very common (and most sensible) format.

Regional settings are in Windows, not Excel. Go to Control Panel, and change
the regional settings there.

Regards,
Fred.
 
D

David Biddulph

If the data had been 19/11/09 instead of 19/11/2009, then it wouldn't have
been unreasonable to interpret it as YY/MM/DD instead of DD/MM/YY, but to
interpret the data as YY/MM/YYDD instead of DD/MM/YYYY would be strange.
 
D

Dave Peterson

Check your other post.
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 recitfy 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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top