Rob,
The Excel v. VBA handling of booleans seems a bit screwy. Assuming A1=TRUE:

?range("A1").Value=true
True
?-range("A1").Value=true
False
?--range("A1").Value=true
True
?10*range("A1").Value
-10
?10*--range("A1").Value
-10

I can't see the logic for all the above to be valid.

NickHK

"Rob van Gelder" wrote in message
...
It's a thing that Frank does so that people ask what it is :)

But seriously...
It's a double unary operator - it has special uses.

There's a great thread about it - he

http://groups.google.com/groups?hl=e...10528.5bb58 1
37%40posting.google.com

And here's some good reading:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"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?