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

[Guest]

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

 

[Guest]

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).

 

[ward376]

or try -

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

 

[Gord Dibben]

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