Dave F said:
Is there an official term for the double hyphen operator, -- ?
Double hyphen doesn't really sound informative. Double negation is not
the answer because -- does not make negative numbers positive.
Well, your first mistake is thinking that "--" is "an" operator. It
is simply two operators in a row, specifically two unary minus
operators. You could write -+-+-+(expr) with the same effect, if it
suits you. What is the term for that? (Rhetorical question.)
Secondly, the only purpose for writing two unary minus signs in that
manner is precisely for the reason that you dismiss, namely double
negation. The only reason why people use two unary minuses is to
cause Excel to treat the operand as numeric. We need two minuses to
double-negate the operand (i.e. negate it twice) in order to leave is
original value unchanged, whether it was positive or negative to begin
with.
In conclusion, I would not call "--" any operator, be it "the double
negation operator" or "the double unary minus" operator. But I
certainly would not call "the double unary [operator]". After all, "+
+" is also a "double unary operator".