import dates from excel spreadsheet (problem?)

[Guest]

I'm trying to import a spreadsheet with a date field
in the following format: dd/mm/yy. In this case the column
has the value 16/12/06. After importing the file to access the
date has changed to 12/06/2016. Is there a way to get the
date in the same format as it is formatted in the excel spreadsheet
file?? Thanks.

 

[John Nurick]

Hi Eric,

Assuming the dates in the worksheet are Excel date values and not text
values, the first thing to do is to check the date format in the
computer's regional settings control panel applet.

Also, check that the date values in the worksheet are actually correct.
You could use this formula, replacing X1 with an actual cell address
=TEXT(X1,"dd MMMM yyyy")
If this produces 12 June 2016 instead of 16 December 2006 the problem is
in the worksheet.