Previous Topic Next Topic

Date format change in excel

Solved/Closed
booor
Posts
2
Registration date
Monday June 30, 2014
Status
Member
Last seen
July 1, 2014
 - Jun 30, 2014 at 07:15 AM
booor
Posts
2
Registration date
Monday June 30, 2014
Status
Member
Last seen
July 1, 2014
 - Jul 1, 2014 at 02:42 AM
Hi,
I have an excel worksheet with a date column in the format m/d/yyyy h:mm:ss AM/PM. How can I change it to the format d/m/yyyy h:mm? I tried the 'format cells' option but could not manage. Any ideas? Thanks!

2 replies

Answer 1 / 2
Blocked Profile
Jun 30, 2014 at 01:50 PM
Ok, give this a try:
=TEXT(O19,"d/mm/yyyy h:mm")

Where O19 is the value you wish to have converted.

I hope this helps!
0
Answer 2 / 2
booor
Posts
2
Registration date
Monday June 30, 2014
Status
Member
Last seen
July 1, 2014
Jul 1, 2014 at 02:42 AM
An error occurs when I type this.
Finally I managed to fix the dates another way. That'll do the job for me.
Thanks for your help!
-1