date formating

steve hill

Board Regular
Joined
Jul 11, 2006
Messages
155
Hi I am trying to keep an eye on my mobile data usage. I can down load the data to excel but the date appears like this
Thu Jul 29 11:51:18 BST 2010 format is general.
what I am trying to do is change it to normal date format dd/dd/yy, if this can be done by time as well would be great but not essentual. I will then be able to sort by date

thanks for your time
steve
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,109,084
Messages
5,526,755
Members
409,717
Latest member
Oscarsalone

This Week's Hot Topics

Top