"bpeltzer" wrote:
.. If so, I'd use Data Text to Columns,
with the delimited option to break
each yyyymmdd into its components ...

Perhaps with Data Text to Columns there's no need to break further ? Just
select the source col of "dates", click Data Text to Columns, click Next
Next, and in Step 3 (under "Column data format"): check "Date", select "YMD"
from the droplist, click Finish. Then just format the converted col as
"Date" (to taste).
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--