From: Rob P on
is there anyway to convert a TEXT field with a date into an excel
recognised date?

or the other way around - convert a date in excel into text output?
From: Bob Phillips on
Try Text>Data To Columns, third page in the wizard.

--

HTH

Bob

"Rob P" <gwatcheater(a)gmail.com> wrote in message
news:f574bab6-e53d-4d72-9fec-8c197cf174f3(a)j27g2000yqn.googlegroups.com...
> is there anyway to convert a TEXT field with a date into an excel
> recognised date?
>
> or the other way around - convert a date in excel into text output?