It is generally used to convert either text or a boolean to an equivalent
number.
Put '42 into cell A1. =-A1 gives -42, =--A1 gives 42
Similarly FALSE is converted to zero, and TRUE to 1.
--
David Biddulph

"JoelS" wrote in message
...
What does "--" do when used in a formula?