VBA - excel import - changed date format

**Damian84** · 03-09-2012, 11:03 AM

Hi all,

In my VBA, I import excel sheet (my raw data) from location x drive. This excel sheet consists of a couple of columns like:

Name - BirthDate - MarriageDate
Ivan 30/06/1984 - 01/07/2011

However when it is gets imported, the dates change into the following format: 40954 (5 digit number)

I can manually adjust it back to the desired format, but would liek to skip the manual work around? Any ideas what causes the below format change and how I may correct it?

Thank you in advance.

**Domski** · 03-09-2012, 11:06 AM

Are you using text import to do this? If so you just need to specify that column as a date as part of the import process.

It might help to see your code.

Dom

**Kelshaer** · 03-09-2012, 11:07 AM

Use this for changing the format of the variable

Please Login or Register  to view this content.

or this to change the format of the cell

Please Login or Register  to view this content.

**Damian84** · 03-09-2012, 12:24 PM

Originally Posted by Domski

Are you using text import to do this? If so you just need to specify that column as a date as part of the import process.

It might help to see your code.

Dom

Hi there,

No, I import in excel format, and in the original file the format of those columns is set up as a date, thus I do not see what is causing this format change. In my VBA, I just have import column B:C, thus I do not see how I may include the format in the VBA.

Thx,