View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
phil phil is offline
external usenet poster
 
Posts: 201
Default 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