Formatting date fields after export

R

Raymond

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

Peo Sjoblom

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

Regards,

Peo Sjoblom
 
D

Dave Peterson

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)!
 
Top