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?
|