Excel, changed format Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy
Closed
jtijerino
Posts
1
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
February 5, 2015
-
Feb 5, 2015 at 02:01 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 9, 2015 at 01:39 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 9, 2015 at 01:39 AM
Related:
- Excel, changed format Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy
- Fc 24 free download for pc windows 11 - Download - Sports
- Microsoft excel mod apk for windows 11 - Download - Spreadsheets
- Ms access free download for windows 11 - Download - Databases
- Net send windows 11 - Guide
- How to change date format in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 9, 2015 at 01:39 AM
Feb 9, 2015 at 01:39 AM
suppose it is in F8 in some other cell use this formula
=RIGHT(F8,LEN(F8)-5)+0
depending upon your region (control panel - regions and language-short date)
the result will be either d/m/yy or m/d/yy
you than formats date as you like
=RIGHT(F8,LEN(F8)-5)+0
depending upon your region (control panel - regions and language-short date)
the result will be either d/m/yy or m/d/yy
you than formats date as you like
