Excel conversion
Closed
pete3566
Posts
1
Registration date
Monday August 6, 2012
Status
Member
Last seen
August 6, 2012
-
Aug 6, 2012 at 11:15 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 8, 2012 at 12:02 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 8, 2012 at 12:02 AM
Related:
- Excel conversion
- Unit conversion excel sheet free download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 8, 2012 at 12:02 AM
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.
