How do I convert 20091115 to date format in excel?

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.
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change dates input as 20080426 to date format in Excel? 7
Why can't I convert Long date format to Short date 1
Date Format 7
Excel date format YYYYMMDD 1
Date Conversion 1
How do I convert date/time formats differently? 4
how do I convert date format yyyymmdd to mm/dd/yyyy 2
Excel Query Wizard Date Format 1

Top