Thread: How do I convert US style dates to European style?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default 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??


Reply With QuoteReply With Quote