View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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