D
dadams
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.
YYYYMMDD and I need for excel to recognize this as a date.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
D
dadams
It worked fabulously, thanks!
Gary''s Student said:=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
G
Gord Dibben
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
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
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
and go to format. then on the number tab find date. click ok. youre done
T
T. Valko
Another one...
A1 = 20091115
=--TEXT(A1,"0000\/00\/00")
Format as Date
A1 = 20091115
=--TEXT(A1,"0000\/00\/00")
Format as Date