Hi and welcome to the forum
The way you have downloaded your data makes it almost impossible to convert to dates. For instance, if you take your last sample...
1232012...that could be
1/23/2012
or
12/3/2012
How would you know the difference? Is there any other way that you could pull that data in that could make the dates 01232012 - ie 8 digits?
Last edited by FDibbins; 02-11-2013 at 04:56 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Acct4life 
Register To Reply
Bookmarks