Convert general format to date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NickC - 05 Feb 2006 05:48 GMT

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

Reply to this Message

Ragdyer - 05 Feb 2006 06:24 GMT

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.

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> I recently scanned a number of newspaper articles and saved them as PDF
> files using this as filename: article_newspaperddmmyy
[quoted text clipped - 8 lines]
>
> Thanks for your help

Reply to this Message

NickC - 05 Feb 2006 22:56 GMT

Thanks. It worked

> You can accomplish the separation of the date portion *AND* the formatting
> of *that* date column in one shot, while you're in TTC.
[quoted text clipped - 22 lines]
> >
> > Thanks for your help

Reply to this Message

RagDyeR - 06 Feb 2006 15:24 GMT

Appreciate the feed-back.

Signature

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

Thanks. It worked

> 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

> the date column to select it.
> Then, under "Column Data Format", in the upper right portion of the wizard
[quoted text clipped - 3 lines]
>
> Now, when you click "Finish", TTC will automatically format your date

column

> at the same time as it performs the data separation.
> > I recently scanned a number of newspaper articles and saved them as PDF
[quoted text clipped - 3 lines]
> > 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 thisI
> > have a problem example 050206 appears as 50206, the leading zero
[quoted text clipped - 3 lines]
> >
> > Thanks for your help

Reply to this Message