Convert general format to date

N

NickC

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
 
R

Ragdyer

You can accomplish the separation of the date portion *AND* the formatting
of *that* date column in one shot, while you're in TTC.

In the 3rd step of the TTC wizard, *before* you click on "Finish", click on
the date column to select it.
Then, under "Column Data Format", in the upper right portion of the wizard
window, click on "Date", and then make sure DMY is in the adjoining box.
The header of your selected date column in the "data preview" box should
change from "General" to "DMY".

Now, when you click "Finish", TTC will automatically format your date column
at the same time as it performs the data separation.
 
N

NickC

Thanks. It worked
Ragdyer said:
You can accomplish the separation of the date portion *AND* the formatting
of *that* date column in one shot, while you're in TTC.

In the 3rd step of the TTC wizard, *before* you click on "Finish", click on
the date column to select it.
Then, under "Column Data Format", in the upper right portion of the wizard
window, click on "Date", and then make sure DMY is in the adjoining box.
The header of your selected date column in the "data preview" box should
change from "General" to "DMY".

Now, when you click "Finish", TTC will automatically format your date column
at the same time as it performs the data separation.
--
HTH,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -
Click to expand...
 
Top