Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get my Excel not to convert everything to date format? | Excel Discussion (Misc queries) | |||
Convert an Excel date to a date of my format in VBA | Excel Programming | |||
How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
Oracle Date format | Excel Programming |