How do I sort dates that are not formatted correctly?
What dates are these?
Are they dates in August (Aug 8, Aug 11, Aug 1) or is it Aug 8, Nov 8, and Jan
1?
Before you try this, make sure that the date order (mdy or dmy or whatever)
matches the windows regional settings for short dates (under the control panel).
Then select your range to fix and
edit|Replace
what: / (slash)
with: /
replace all
If you change that windows regional date setting, then change it back when
you're done and format the cells the way you want.
curious1 wrote:
8/8/2006
8/11/2006
8/1/2006
I cannot get the above dates to sort correctly in descending order when
imported from another source.
--
Dave Peterson
|