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
- How to change date format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Kingston format utility - Download - Storage
- How to clear formatting in excel - Guide
- Kernel for excel repair - Download - Backup and recovery
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