PC Review


Reply
Thread Tools Rate Thread

Change date from yyyymmdd to valid date format

 
 
denilynn
Guest
Posts: n/a
 
      2nd Sep 2009
I imported data from an industry-specific software into Excel. The 09/02/09
date, for example, converted to 20090902 in Excel. How can I change this to a
valid date format?
--
Thanks in advance for your time!
denilynn
 
Reply With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      2nd Sep 2009
--Select the range of dates which needs to be corrected.
--From menu Data>Text to Columns will populate the 'Convert Text to Columns
Wizard' Hit Next>Next will take you to Step 3 of 3 of the Wizard.
--From Column Data format select Date and select the date format in which
your data is (YMD).
--Hit Finish. MSExcel will now convert the dates to the default date format
of your computer.


If this post helps click Yes
---------------
Jacob Skaria


"denilynn" wrote:

> I imported data from an industry-specific software into Excel. The 09/02/09
> date, for example, converted to 20090902 in Excel. How can I change this to a
> valid date format?
> --
> Thanks in advance for your time!
> denilynn

 
Reply With Quote
 
Luke M
Guest
Posts: n/a
 
      2nd Sep 2009
something like this:

=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))

will convert to a standard XL date.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"denilynn" wrote:

> I imported data from an industry-specific software into Excel. The 09/02/09
> date, for example, converted to 20090902 in Excel. How can I change this to a
> valid date format?
> --
> Thanks in advance for your time!
> denilynn

 
Reply With Quote
 
denilynn
Guest
Posts: n/a
 
      2nd Sep 2009
Very cool! You saved me hours!
--
Thanks in advance for your time!
denilynn


"Jacob Skaria" wrote:

> --Select the range of dates which needs to be corrected.
> --From menu Data>Text to Columns will populate the 'Convert Text to Columns
> Wizard' Hit Next>Next will take you to Step 3 of 3 of the Wizard.
> --From Column Data format select Date and select the date format in which
> your data is (YMD).
> --Hit Finish. MSExcel will now convert the dates to the default date format
> of your computer.
>
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "denilynn" wrote:
>
> > I imported data from an industry-specific software into Excel. The 09/02/09
> > date, for example, converted to 20090902 in Excel. How can I change this to a
> > valid date format?
> > --
> > Thanks in advance for your time!
> > denilynn

 
Reply With Quote
 
denilynn
Guest
Posts: n/a
 
      2nd Sep 2009
This worked! Thanks!!
--
Thanks in advance for your time!
denilynn


"Luke M" wrote:

> something like this:
>
> =DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
>
> will convert to a standard XL date.
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "denilynn" wrote:
>
> > I imported data from an industry-specific software into Excel. The 09/02/09
> > date, for example, converted to 20090902 in Excel. How can I change this to a
> > valid date format?
> > --
> > Thanks in advance for your time!
> > denilynn

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I change the date format from yyyymmdd to mm/dd/yyyy Charlene Microsoft Excel Worksheet Functions 4 16th Sep 2009 08:13 PM
How do I change date yyyymmdd to a Excel-supported date format? dan Microsoft Excel Worksheet Functions 3 6th Jul 2008 11:05 PM
How do you change a date that is in the yyyymmdd format to mmddyy =?Utf-8?B?Tm9ydG9u?= Microsoft Excel Misc 2 8th Mar 2006 03:15 PM
Need macro to change date from yyyymmdd format to mm/dd/yyyy forma =?Utf-8?B?SXJpcw==?= Microsoft Excel Programming 3 16th Nov 2005 10:29 PM
Date format change from yyyymmdd to mm/dd/yyyy =?Utf-8?B?UGV0ZXI=?= Microsoft Excel Misc 1 3rd Dec 2003 09:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:35 AM.