TTC is usually the easiest and the best way to convert this type of text to
true dates,
*BUT*
In the third page of the wizard, after clicking on "Date",
One must realize that the format to click on,
Is *not* the format you want to display,
BUT the format that the present text is currently in.
You're telling TTC where to convert *from*.

If this choice is not done correctly, either no conversion will be made (not
so bad), or a wrong conversion will be made (bad).

After the true dates are established, then they can be custom formatted to
the desired display.
--
Regards,

RD

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

"Gary''s Student" wrote in message
...
What I got was:

120100 12 1 0 12/1/1900

I see your point. My method will always map into the last century.
Good catch!
--
Gary's Student


"Biff" wrote:

Try that with this:

120100

Biff

"Gary''s Student" wrote in
message
...
In A1: 81096
In B1: =INT(A1/10000) month part shows 8
In C1: =INT((A1-10000*B1)/100) day part shows 10
In D1: =A1-10000*B1-100*C1 year part shows 96
In E1: =DATE(D1,B1,C1)
--
Gary's Student


"Frank Winston" wrote:

Is there a way to convert a column of text, date values (entered as
81096,
for example) to valid date format, 8/10/96? I could not get the
DATEVALUE
function to do this.