Excel conversion
Closed
pete3566
venkat1926
- Posts
- 1
- Registration date
- Monday August 6, 2012
- Status
- Member
- Last seen
- August 6, 2012
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Excel conversion
- Excel conversion calculator - Download
- Julian date excel conversion ✓ - Forum - Excel
- Date conversion in excel - Guide
- Number to words conversion in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 reply
venkat1926
Aug 8, 2012 at 12:02 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Aug 8, 2012 at 12:02 AM
how did you enter the data in excel (as EXCEL DAT according to regional convention) or did you just enter it just as a number
suppose you have entered as EXCEL DATE
you format-cells-custom
type
mm/dd/yy and hit ok
if you have typed it as number e.g. 20120808 thsen
in another cell type
=(MID(E73,5,2)&"/"&RIGHT(E73,2)&"/"&LEFT(E73,2))*1
E73 is the cell where the date is .l you modify the formula
(this is according to my regional date entry convention that is m/d/yy
ALWAYS ENTER DATE AS EXCEL DATE ACCORDING TO YOUR REGIONAL CONVENTION. THEN IT IS EASY TO MANIPULATE.
suppose you have entered as EXCEL DATE
you format-cells-custom
type
mm/dd/yy and hit ok
if you have typed it as number e.g. 20120808 thsen
in another cell type
=(MID(E73,5,2)&"/"&RIGHT(E73,2)&"/"&LEFT(E73,2))*1
E73 is the cell where the date is .l you modify the formula
(this is according to my regional date entry convention that is m/d/yy
ALWAYS ENTER DATE AS EXCEL DATE ACCORDING TO YOUR REGIONAL CONVENTION. THEN IT IS EASY TO MANIPULATE.