When I copied and pasted your date from your post to my XL97 it automatically
converted it to a date of 4/7/1991. Apparently your date in your workbook is
formatted as TEXT. It can be busted any number of ways. You can put a 1 in
an unused cell and select it and do Copy then select your date cell(s)
and do PasteSpecial Values......this will turn 1991-04-07 into 33335, the
excel equivelent of April 7, 1991. You can then just format it for DATE as
you wish. Or, you can select the date column and do Data TextToColumns
and format it as date......

hth
Vaya con Dios,
Chuck, CABGx3



"Maclaren" wrote:

I have a lot of dates that need to be changed from 1991-04-07 to a format
recognised by Excel as a date format, does anyone know a quick way of doing
this other than rewriting them all?