| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert 20091115 to date format in excel?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert 20091115 to date format in excel?
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
-- Gary''s Student - gsnu200909 "dadams" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert 20091115 to date format in excel?
It worked fabulously, thanks!
"Gary''s Student" wrote: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) -- Gary''s Student - gsnu200909 "dadams" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert 20091115 to date format in excel?
Just for info.
If you select the column of dates and DataText to ColumnsNextNextColumn Data FormatDateYMD and Finish, you will get real dates. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 11:28:01 -0800, dadams wrote: It worked fabulously, thanks! "Gary''s Student" wrote: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) -- Gary''s Student - gsnu200909 "dadams" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert 20091115 to date format in excel?
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 "dadams" wrote: 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert 20091115 to date format in excel?
Another one...
A1 = 20091115 =--TEXT(A1,"0000\/00\/00") Format as Date -- Biff Microsoft Excel MVP "dadams" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert Julian Date Format to Excel | Excel Discussion (Misc queries) | |||
| convert julian date format to excel | Excel Discussion (Misc queries) | |||
| convert Julian Date Format to Excel | Excel Discussion (Misc queries) | |||
| How do I get my Excel not to convert everything to date format? | Excel Discussion (Misc queries) | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
Hybrid Mode
