Record a macro and you will have one. It should include...
Replacing the quote marks and apostrophe with nothing (Edit | Replace)
Multiplying all of the dates by 1 (Edit | Paste Special | Multiply)
Changing the number format to mm/dd/yy (Format | Cells | Number (tab) | Custom
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)





wrote in message
Does anyone have a good macro for taking date data that are in a
variety of formats and making them consistent? By format, I don't mean
that the cells are formatted differently, but that the data are all
recorded as, say, a string, but they all look different, e.g.

"01/05/92"
"01-07-84"
"Jan 12, 1991"
"January 1, 2000"
"10 January '05"

Is there any macro that is written to recognize that, say, the first
two are in mm/dd/yy format and to put them into a consistent style,
that the second, third, and fourth are in different formats, and to
put them into mm/dd/yy, etc.?