Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change date from yyyymmdd to valid date format
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change date from yyyymmdd to valid date format
--Select the range of dates which needs to be corrected.
--From menu DataText to Columns will populate the 'Convert Text to Columns Wizard' Hit NextNext 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change date from yyyymmdd to valid date format
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change date from yyyymmdd to valid date format
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 DataText to Columns will populate the 'Convert Text to Columns Wizard' Hit NextNext 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change date from yyyymmdd to valid date format
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change date yyyymmdd to a Excel-supported date format? | Excel Worksheet Functions | |||
Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
I need a yyyymmdd date format with no dashes | Excel Discussion (Misc queries) | |||
Is there an Excel date format as follows: yyyymmdd? | Excel Discussion (Misc queries) | |||
How do you change a date that is in the yyyymmdd format to mmddyy | Excel Discussion (Misc queries) |