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
Hello,

I'm looking to convert the following excel format of "Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy.

Thanks in advance for your answers.

jtijerino

Related:

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
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
0