Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert US style dates to European style?
Is it possible to import data containing American style dates, eg. 10/15/06,
and convert them to European style dates eg. 15/10/06?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert US style dates to European style?
If 10/15/06 is in a cell, then
Format Cell... Custom and enter d/m/yy to see 15/10/06. These are different displays of 39,005 -- Gary's Student "Neo" wrote: Is it possible to import data containing American style dates, eg. 10/15/06, and convert them to European style dates eg. 15/10/06?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert US style dates to European style?
Easiest is to temporarily set Window's date format to American. After importing you can change it back and then the dates will be
"converted" automatically. -- Kind regards, Niek Otten Microsoft MVP - Excel "Neo" wrote in message ... | Is it possible to import data containing American style dates, eg. 10/15/06, | and convert them to European style dates eg. 15/10/06?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert US style dates to European style?
If the data is in a text file, I'd make sure the name of the file had an
extension of .txt. Then just File|Open that Text file. The data import wizard will appear and you'll be able to specify that this field is a date in mdy order. Then after the import, just change the number format to dd/mm/yyyy. Neo wrote: Is it possible to import data containing American style dates, eg. 10/15/06, and convert them to European style dates eg. 15/10/06?? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make my borded automatic black instead of pink? | Excel Worksheet Functions | |||
Convert three separate columns of values to dates | Excel Worksheet Functions | |||
CONVERT 11/23/04 US DATE FORMAT TO EUROPEAN 23/11/04 FATE | Excel Discussion (Misc queries) | |||
Any way to force European format dates in sheets? | New Users to Excel | |||
Convert text to dates | Excel Worksheet Functions |