Link to home
Start Free TrialLog in
Avatar of Nigel Pinnock
Nigel PinnockFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Formatting Dates Again!

I have market data that I input into an array then copy to a worksheet.  For format of the text files is as follows:
10032005,3910,3910,3910,3910,10,3,2
1022007,3910,3910,3910,3910,10,3,2
The first column is the date in the format  mm/dd/yyyy,  But the month may be 1 or 2 chars i.e "1" not "01".

When I format my cell in excel to be a date in the form mm/dd/yyyy the input text 10032005 does not give me 10/03/2005 but 10/04/2020.  I need to use VBA to get the correct result.  But can anyone explain this?  
ASKER CERTIFIED SOLUTION
Avatar of mattbroomhall
mattbroomhall

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial