If you're going to enter these in a column, then you can use TTC (Text To
Columns) to transform them into XL recognizable dates.
You'll need all 6 digits to avoid confusion, or else TTC will simply *not*
return a date, or return a wrong date.

Select the column of data, and then,
<Data <Texr To Columns <Next <Next

And under "Column Data Format"
Click on "Date",
And choose the date format you currently *have* (not what you want them to
be when you're done).

The numbers you used in your example (020104) could actually represent *all*
date formats.

So you'll have to stipulate whether they're *presently*:
mdy
dmy
or even
ymd

Then <Finish

TTC will kick out any numbers that don't fit the format you picked.

Now you can select the column of dates, and re-format them to the display
you wish if you're not satisfied with the default format TTC used.

--

HTH,

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


"Helpless" wrote in message
...
I am trying to figure a way to type in a date in pure numbers such as 020104
and for it to show in the cell as the date 02/04/04 in this format.

Please help