View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

It is probably seen as text,
select the imported dates, do datatext to columns,
click next twice, under column data format select date and YMD
click finish

Regards,

Peo Sjoblom


"Raymond" wrote:

I am experiencing problems with my exported date fields into Excel from other
applications. The data formats to "yyyy-mm-dd" and cannot be modified unless
I double-click on each field. Has anyone else experienced this problem? And
what solutions would you suggest?