So very cool!
Thanks for the help!

"Ron Coderre" wrote:

I think you can do what you want all in one step:

Select the "date" cells
DataText-to-columns
Delimited...Click Next
(Doesn't matter what the delimiter is)...Click Next
Click the Date option and set the dropdown to YMD...Click Finish
That should turn those numbers into dates.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Russell-stanely" wrote:

I have a worksheet (in 2000) that was sent to me. The information in the
worksheet was culled from an Access database that I have no access to, and
saved to Excel.

There are several columns of dates that came over as "general" in this format:
20031125.
I want to quickly convert this into the proper date format of 11/25/03, but
I cannot seem to figure out a quick method to do it in Excel 2000.
HELP!