Excel Date Format
Closed
baker5801
Posts
1
Registration date
Monday August 27, 2012
Status
Member
Last seen
August 27, 2012
-
Aug 27, 2012 at 11:24 AM
Baker5801 - Aug 28, 2012 at 06:04 AM
Baker5801 - Aug 28, 2012 at 06:04 AM
Related:
- Excel Date Format
- Excel date format dd.mm.yyyy - Guide
- Marksheet format in excel - Guide
- Format factory - Download - Other
- Kingston format utility - Download - Storage
- Samsung format code - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 28, 2012 at 12:52 AM
Aug 28, 2012 at 12:52 AM
suppose the number 20120131 is in E12 use this formula
change the cell address according to you
=DATE(LEFT(E12,4),MID(E12,5,2),RIGHT(E12,2))
change the cell address according to you
=DATE(LEFT(E12,4),MID(E12,5,2),RIGHT(E12,2))
Aug 28, 2012 at 06:04 AM