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 |
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 |
All times are GMT +1. The time now is 09:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com