Are those yy-mmdd
If yes and yy are all in this century, you could use a helper cell and this
formula:

=--TEXT(--SUBSTITUTE(A1,"-",""),"\2\000\/00\/00")
format as date and drag down.



Pam Coleman wrote:

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.

--

Dave Peterson