View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Emece Emece is offline
external usenet poster
 
Posts: 82
Default Convert dates stored as text

I have Excel 2007 in English, but I sometimes receive data that comes from
another applicationes, so dates are stored as text because they come in
following format: dd/mm/yyyy. And I have the format mm/dd/yyyy.

So, in the same column, I have dates stored as dates, and dates stored as
text. Which is the easiest way to convert them all to date format?

Thanks in advance.

Regards,
Emece.-