I have been sent a file with dates. Some of the dates are appearing in the incorrect format. One date shows 8/10/2010 when it should be 10/8/2010. When I look at format of cell it shows English UK.Other dates appearing correctly have just general format. The sender of the file(US subsidary) confirms it displays correctly on her side.Wondering if anyone can advise where the problem might arise from. Many Thanks
It seems strange that some cells with dates are OK and others are not. This would lead me to suspect that the originator does not know how to specify and maintain data formatting, validation and integrity rules on a column by column basis.... I need to know why it is happening to ensure that in futre I can be confident in the integrity of my data.
I've found that this issue usually happens with data that is not created in Excel but exported/imported into Excel. In your case it might be that the data is imported into Excel in the States from a Txt file or CSV file. When it is done in the States, Excel gets it "right" - file is in mm/dd/yyyy format and is imported into Excel that expects and understands mm/dd/yyyy... That would explain why your colleague in the States says it is OK for her...I have been sent a file with dates...Wondering if anyone can advise where the problem might arise from.
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?