Sometimes the easiest way is to just do a find and replace on the 00 with 00.
Make sure it takes a partial match. When the replace is done the cell is
canged and Excel will do an implicit conversion of the value (same as hitting
F2).
--
HTH...

Jim Thomlinson


"Phil" wrote:

Good afternoon;

I have data I am downloading to excel from an oracle database. The date is
either fixed text or ansi and displays as 2007-06-08. I can not simply change
the date format. The only way it will change is if I do an "F2" on each cell.
This may be fine for 10 dates, however, I am looking a 2 columns totalling
600 dates each column. I need something that will convert these easily into
mm/dd/yyyy, and still maintian the correct date.
Does any one have any suggestions

Thanks Phil