Date format change in excel
Solved/Closed
booor
booor
- Posts
- 2
- Registration date
- Monday June 30, 2014
- Status
- Member
- Last seen
- July 1, 2014
booor
- Posts
- 2
- Registration date
- Monday June 30, 2014
- Status
- Member
- Last seen
- July 1, 2014
Related:
- Date format change in excel
- Date format change in excel - Guide
- Why won't the date format change in excel ✓ - Forum - Excel
- Excel conditional formatting change text color ✓ - Forum - Excel
- Date format not changing in excel 2007 ✓ - Forum - Excel
- How to change the date format in Excel 2007 ✓ - Forum - Excel
2 replies
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
Jul 1, 2014 at 02:42 AM
- 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!
Finally I managed to fix the dates another way. That'll do the job for me.
Thanks for your help!