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

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

or try -

With Range("YourRange")
.Value = .Value
End With

Try Data>Text to Columns>Next>Next>Column Data Format>Date YMD and Finish.

Most times a simple Data>Text to Columns>Finish will do the trick.


Gord Dibben MS Excel MVP


On Fri, 8 Jun 2007 13:17:01 -0700, Phil <(E-Mail Removed)> 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