Maybe you can try this (Edit|Undo if it doesn't work).

Select your range

Edit|Replace
what: (space)200
with: ,(space)200
replace all

If you have dates in the 1900's you'll have to do the equivalent for them.

Then one more time (maybe twice):

Edit|replace
what: PM
with: (space)PM
replace all

And the same for AM.

When I did this, excel saw the cells as dates/times and I could format them the
way I wanted--but the sorts were by dates.

Kyli wrote:

I have column filled with:
'Apr 3 2005 4:37PM

And I need to change it to:
04/03/05 4:37PM

How do I get a textual date column into a sortable date/time column? I'm
having problems because it sorts everything by alpha then numeric. For
example, I have "Apr 15, 2005" before "Aug 10, 2003". I need to get these
sorted by year, month, day...not alphabetically. Thanks in advance for your
help!

--

Dave Peterson