I recently scanned a number of newspaper articles and saved them as PDF
files using this as filename: article_newspaperddmmyy
e.g. Big story_FreePress050206 where 050206 refers to February 5, 2006. I
have a folder with over 300 filenames like that. I used a PrintFolder
program to list these filenames and export them into Excel. By using the
Text to Columns feature I was able to place the date reference part of the
filename into a separate column. However I notice that after doing this I
have a problem example 050206 appears as 50206, the leading zero disappears.
How can I convert this General Format number to a date format such as
dd-mm-yy

Thanks for your help