| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
