Excel conversion
Closed
pete3566
Posts
1
Registration date
Monday 6 August 2012
Status
Member
Last seen
6 August 2012
-
6 Aug 2012 à 11:15
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 Aug 2012 à 00:02
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 Aug 2012 à 00:02
Related:
- Excel conversion
- Mouse conversion pro apk - Download - Mouse and keyboard
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
8 Aug 2012 à 00:02
8 Aug 2012 à 00:02
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.
