20061005 should be a valid date format in Excel

[Guest]

When we download from our data base the dates are in this format CCYYMMDD.
This is not a valid date within Excel so we can not format it will slashes
when it comes in.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...2fceb1f&dg=microsoft.public.excel.programming

 

[Guest]

Tschimek,

You are correct that Excel will not automatecally convert date data from
your database extract directly into dates. However, if you import the date
data as Text, the following formula would convert the text date in Cell A1
into an Excel date: =Date(Left(A1,4),Mid(A1,5,2),Mid(A1,7,2))

John