Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date conversion
How can I convert dates from 20020113 to 1/13/02?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date conversion
Hi,
If 20020113 is a properly formatted date then simply change the cell format to m/dd/yyyy If it isn't a correctly formatted date then post back. Mike "Charlie7805" wrote: How can I convert dates from 20020113 to 1/13/02? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date conversion
If the 20020113 is in cell A1, then enter in B1 =LEFT(A1,4) and in cell C1
=MID(A1,5,2) and in cell D1 =MID(A1,7,2) and then in cell E1 =DATE(B1,C1,D1). let me know if that helps. "Charlie7805" wrote: How can I convert dates from 20020113 to 1/13/02? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date conversion
This works perfectly. Thanks!!!
"art" wrote: If the 20020113 is in cell A1, then enter in B1 =LEFT(A1,4) and in cell C1 =MID(A1,5,2) and in cell D1 =MID(A1,7,2) and then in cell E1 =DATE(B1,C1,D1). let me know if that helps. "Charlie7805" wrote: How can I convert dates from 20020113 to 1/13/02? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date conversion
DataText to ColumnsNextNextColumn Data FormatDateYMD and Finish.
Gord Dibben MS Excel MVP On Tue, 4 Mar 2008 10:07:03 -0800, Charlie7805 wrote: How can I convert dates from 20020113 to 1/13/02? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Conversion | Excel Discussion (Misc queries) | |||
Date Conversion | Excel Discussion (Misc queries) | |||
Date Conversion | Excel Discussion (Misc queries) | |||
Date Conversion - sorry | New Users to Excel | |||
Date Conversion | Excel Worksheet Functions |