| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert US date with 12hr format to European date 24hr
I am using Excel. I have a mix of 24hr and 12hr AM/PM format pulling from a
database. I want to reformat all dates with time to the 24hr clock so that I can then have 1 format to manipulate |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert US date with 12hr format to European date 24hr
If the input data are formatted so that Excel recognises them as times, then
it doesn't matter whether they are 12 hour or 24 hour format. If you want to change them all to one format, use Format/ Cells/ Number/ Time, and choose to suit your preference. You may have problems if your data are treated as text because they have spare spaces or non-breaking spaces. In that case you'd have to change them to real times before formatting them. -- David Biddulph "Enda K" <Enda wrote in message ... I am using Excel. I have a mix of 24hr and 12hr AM/PM format pulling from a database. I want to reformat all dates with time to the 24hr clock so that I can then have 1 format to manipulate |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert european foreign date format to US date format | Excel Worksheet Functions | |||
| convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
| Convert European Date format to American Format | Excel Discussion (Misc queries) | |||
| how can i change european date format to american | Excel Discussion (Misc queries) | |||
| CONVERT 11/23/04 US DATE FORMAT TO EUROPEAN 23/11/04 FATE | Excel Discussion (Misc queries) | |||
Linear Mode
