Excel, changed format Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy [Closed]

Report
Posts
2
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
February 5, 2015
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
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