-- converts numbers returned as text or logical values (TRUE/FALSE) into
numerical values, similar to the function VALUE(), but I think the latter
can't convert the logical values.

KL

"NickHK" wrote in message
...
Frank,
Out of interest, what is the meaning of "--" in Excel formulae ?

NickHK

"Frank Kabel" wrote in message
...
Hi
and another option
=--TEXT(--A1,"0000-00-00")
and format as date

--
Regards
Frank Kabel
Frankfurt, Germany

"German Velasquez" schrieb im Newsbeitrag
om...
hello,
I have a data base with no date format, just a series of numbers like
20041128 for November 28th year 2004. How can I give this information
a date format?