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!
=====================================================
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
