Excel, changed format Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy
Closed
jtijerino
Posts
1
Registration date
Wednesday 4 February 2015
Status
Member
Last seen
5 February 2015
-
5 Feb 2015 à 14:01
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Feb 2015 à 01:39
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Feb 2015 à 01:39
Related:
- Excel, changed format Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy
- How to change date format in excel - Guide
- Excel clear formatting - Guide
- Microsoft excel mod apk for windows 11 - Download - Spreadsheets
- Ms access free download for windows 11 - Download - Databases
- Driver booster 11 - Download - Cleaning and optimization
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
9 Feb 2015 à 01:39
9 Feb 2015 à 01:39
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
