Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS

Closed
asmfiaz Posts 1 Registration date Thursday July 17, 2014 Status Member Last seen July 17, 2014 - Jul 17, 2014 at 06:25 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 17, 2014 at 07:42 AM
Hello all

I have some 1000 cell of date format. which has " 13/05/14 16:53:59 "

Excel not recognize as date.. How can I change..

Tried Format cell too. not working..

Please suggest..


advance thanks and appreciate you for response

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 17, 2014 at 07:31 AM
what is your regional set up

goto
control panel
region and language (or something like that)
see short date and time
that is how you have to ENTER date and time and not in any other way

confirms your regional set up
4