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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,108,979
Messages
5,526,024
Members
409,677
Latest member
ssh99

This Week's Hot Topics

Top