Appreciate the feed-back.
--

Regards,

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

"NickC" <nickcwpg@hotmail.com> wrote in message
news:uMiO1dqKGHA.3944@tk2msftngp13.phx.gbl...
Thanks. It worked
"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:uhV6HzhKGHA.668@TK2MSFTNGP11.phx.gbl...
> 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 !
> --------------------------------------------------------------------------
-
>
> "NickC" <nickcwpg@hotmail.com> wrote in message
> news:%23IAGFfhKGHA.3260@TK2MSFTNGP11.phx.gbl...
> > 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
> >
> >
>