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
|