I have market data that I input into an array then copy to a worksheet. For format of the text files is as follows:
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?