Advertisement

07.05.2007 at 12:07PM PDT, ID: 22677672
[x]
Attachment Details

How do I convert a Text date to a regular date

Asked by jray9242 in Microsoft Excel Spreadsheet Software

Tags: date, convert, excel, vba, text

I have an Excel workbook that has a date like this, "20070608" and of course I need to change it to look like this, "06/08/2007".  How can this be done using a VBA script?

I am using Excel 2003 and my operating system is Windows XP pro.

Thank you

JimStart Free Trial
[+][-]07.05.2007 at 12:18PM PDT, ID: 19426490

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: date, convert, excel, vba, text
Sign Up Now!
Solution Provided By: kanwal_no1
Participating Experts: 3
Solution Grade: A
 
 
[+][-]07.05.2007 at 12:52PM PDT, ID: 19426784

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.05.2007 at 02:52PM PDT, ID: 19427723

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.06.2007 at 10:18AM PDT, ID: 19433342

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32