ExcelBanter - View Single Post - Excel (or other) macro for cleaning date data

Dallman Ross

In .com,
spake thusly:

"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.?

Not sure about a macro, but you can just select the one with the
format you like, click the Format Painter in the Formatting Toolbar,
and drag or click the format along all that you want to use that format.
If you click twice quickly on the Format Painter, it will toggle
"locked" and you can click subsequently on various other cells and
ranges; then, when you're done, click again on the Format Painter
to toggle off.

--
dman