Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
20061005 should be a valid date format in Excel
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/comm...el.programming |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
20061005 should be a valid date format in Excel
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 "tschimek" wrote: 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/comm...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change date from yyyymmdd to valid date format | Excel Discussion (Misc queries) | |||
Excel - File format is not Valid | Excel Discussion (Misc queries) | |||
"File Format Not Valid" When Starting Excel. Error Code 0D3F6000 | Excel Discussion (Misc queries) | |||
Excel File Format SUDDENLY Not Valid-What happened????? | Excel Discussion (Misc queries) | |||
Excel getting Error - file format is not valid WHEN OPENING | Excel Discussion (Misc queries) |