I imported many text file to excel for example one column has date formated in the text file itself as 080911 which is August 9, 2011
My problem is when I imported to excel the leading zero's are droped is there a way to correct without importing all the files again.
80911 when I format as date results in 7-10-2121.
the lengths are all the same 6 character.
Bookmarks