Hi Thomas
this kind of function could return wrong results if the regional date
settings are for example
MM-DD-YYYY
and you have a date like
03042004
which should be
03-Apr-2004
but would be interpreted as
04-Mar-2004

Personally I'd trust DATEVALUE only for a format like
YYYY-MM-DD


--
Regards
Frank Kabel
Frankfurt, Germany


Thomas Ramel wrote:
Grüezi PW

PW schrieb am 10.06.2004

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.

Try the following formula in an column:

=DATEVALUE(TEXT(A1,"00-00-0000"))

and format the cell(s) with 'dd.mmmm yyyy'