On Sat, 29 Dec 2007 18:07:00 -0800, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom
wrote:

Rick

Is there a significant difference between your response and that of RagdyeR?

Mike Rogers

Mike,

Rick's response results in a TEXT string. The result can be used by formulas
that manipulate text. It will ordinarily be left-justified.

Ragdyer's response results in a DATE value being in the cell. The result can
be used by date formulas (the value will be the same date as the original). It
will ordinarily be right-justified.
--ron