Formatting date fields after export
 

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?

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?

If reentering the value in the cell (doubleclicking, then hitting enter) works,
maybe you could just select that range and do:

Edit|replace
what: - (dash)
with: - (dash)
replace all

If that doesn't work, maybe replacing the dash with a slash would work.

(I usually use Peo's suggestion. But this should be quicker (if it works)!

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?

--

Dave Peterson