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
booor Posts 2 Registration date Monday June 30, 2014 Status Member Last seen July 1, 2014 - Jul 1, 2014 at 02:42 AM
Related:
- Date format change in excel
- How to change date format in excel - Guide
- Marksheet format in excel - Guide
- How to change author in excel - Guide
- Format factory - Download - Other
- Change computer name cmd - Guide
2 responses
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!
=TEXT(O19,"d/mm/yyyy h:mm")
Where O19 is the value you wish to have converted.
I hope this helps!
booor
Posts
2
Registration date
Monday June 30, 2014
Status
Member
Last seen
July 1, 2014
Jul 1, 2014 at 02:42 AM
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!
Finally I managed to fix the dates another way. That'll do the job for me.
Thanks for your help!
