D dadams Dec 2, 2009 #1 I have excel 2007 and run a query out of Oracle. The dates appear as YYYYMMDD and I need for excel to recognize this as a date.
I have excel 2007 and run a query out of Oracle. The dates appear as YYYYMMDD and I need for excel to recognize this as a date.
D dadams Dec 2, 2009 #3 It worked fabulously, thanks! Gary''s Student said: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) Click to expand...
It worked fabulously, thanks! Gary''s Student said: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) Click to expand...
G Gord Dibben Dec 2, 2009 #4 Just for info. If you select the column of dates and Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish, you will get real dates. Gord Dibben MS Excel MVP
Just for info. If you select the column of dates and Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish, you will get real dates. Gord Dibben MS Excel MVP
E excelguy Dec 2, 2009 #5 i think you can open an excel file in 2003. once in 2003 excel click the cell and go to format. then on the number tab find date. click ok. youre done
i think you can open an excel file in 2003. once in 2003 excel click the cell and go to format. then on the number tab find date. click ok. youre done
