On Fri, 27 Apr 2012 18:12:25 -0500, mp wrote:

I'll be darned, it's that easy? :-) I wouldn't have intuitively arrived
at that!! :-) thanks a bunch
Mark

Mark,

For safety sake, I would suggest a little more complexity:

For Each c In Selection
If IsDate(c) Then c.Value = c.Value
Next c

Isabelle asked why not just:
Selection = selection.value

And the answer was to avoid converting non-date entries (including, for example, numbers with leading zero's that are in a text format; and also formulas). But I had omitted that test from what I posted earlier.