Hi
one way: use the following formula in an adjacent cell:
=DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2))
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany


PW wrote:
Hello newsgroup users and Gurus.

Your kind assistance please.

This is a challenge.

I have a column with a text string which is a date. i'e.

30121998= 30th December 1998.

I would like to convert the text string into a actual date
format.

A tricky one I know, but is it possible.

Regards
Paul