| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change date format from US to English (Australian)
Hi there, I have to regularly download data from a US site and I need to reformat the dates, does anyone know how to change the formats below: from mm/dd/yyyy h:mm to dd/mm/yyyy h:mm English (US) ................English (Australian) 01/15/2006 05:00 ................15/01/2006 5:00 01/15/2006 05:20 ................15/01/2006 5:20 01/15/2006 05:40 ................15/01/2006 5:40 01/15/2006 06:00 ................15/01/2006 6:00 01/15/2006 06:20 ................15/01/2006 6:20 01/15/2006 06:40 ................15/01/2006 6:40 01/15/2006 07:00 ................15/01/2006 7:00 I have tried to highlight the data then (Format-Cells-Custom) but the mm/dd does not change. At the moment I start a new column with the new format and use the click and drag, however the data is over several months and every day or so it misses some time and then I have to change the dates in two cells to start over again. Hope I am making sense here? Regards ................ Bill -- altona ------------------------------------------------------------------------ altona's Profile: http://www.excelforum.com/member.php...o&userid=34139 View this thread: http://www.excelforum.com/showthread...hreadid=539096 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forcing english date format | Excel Worksheet Functions | |||
| How do I change the date format when importing a txt file? | Excel Worksheet Functions | |||
| I cannot change the date format to English canada | Excel Discussion (Misc queries) | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| Change the format of my footer {date} option? | Excel Discussion (Misc queries) | |||
Threaded Mode
