Converting numbers to date format

**djfscouse** · 10-25-2012, 10:54 AM

Hi,

I have a few columns E,X and Z with the dates in the form of 20120426 and I need to convert it to 04/26/2012 format using VBA in Excel 2003.

Any help is appreciated.

Thanks,

David

**tigeravatar** · 10-25-2012, 12:11 PM

David,

Give this a try:

Please Login or Register  to view this content.

**djfscouse** · 10-25-2012, 06:48 PM

Thanks tigeravatar,

But unfortunately it did not work, here is an example to the data in xls file.

Thanks,

David

**tigeravatar** · 10-25-2012, 06:53 PM

djfscouse,

From your original post:

Originally Posted by djfscouse

I have a few columns E,X and Z with the dates in

However, your provided example file has the dates in columns E, Y, and AA. The macro is easy enough to adjust though:

Please Login or Register  to view this content.

**djfscouse** · 10-29-2012, 12:34 PM

Thanks again tigeravatar, sorry for the original info.

**Armando Montes** · 10-29-2012, 01:59 PM

Another way:
http://www.youtube.com/watch?v=HnphWTpmV8Y

Converting numbers to date format

LinkBack

Thread Tools

Rate This Thread

Display

Converting numbers to date format

Re: Converting numbers to date format

Re: Converting numbers to date format

Re: Converting numbers to date format

Re: Converting numbers to date format

Re: Converting numbers to date format

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions