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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,108,728
Messages
5,524,486
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top