Pam,

Assuming your dates are in column A, put the following formula in
column B

=DATE("20"&LEFT(A1,2),MID(A1,4,2),RIGHT(A1,2))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Pam Coleman" wrote in
message
...
If I have dates listed in a column as 06-0101 etc, how can I
format it to
be: 20060101? I have 7000 rows where I need to reformat the
date.
Help.