Date Format

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 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)
 
D

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.
 

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

Date format getting muddled 3
How to enter a date in DD-MM-YYYY format 2
date format convert 3
Default date format 4
convert to date format 3
Date Format 3
Format Date in Header 2
Concatenate Text, Number and Date 2

Top