Re: Excel 2000 work*** where I want to convert date format

"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
--


.