convert date from oracle format to MS Excel mm/dd/yyyyy
 

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

convert date from oracle format to MS Excel mm/dd/yyyyy
 

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

convert date from oracle format to MS Excel mm/dd/yyyyy
 

or try -

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

convert date from oracle format to MS Excel mm/dd/yyyyy
 

Try DataText to ColumnsNextNextColumn Data FormatDate YMD and Finish.

Most times a simple DataText to ColumnsFinish will do the trick.


Gord Dibben MS Excel MVP


On Fri, 8 Jun 2007 13:17:01 -0700, 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