The MID function returns a string/text result. The -- converts
the text result to a number.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"John Michl" wrote in message
oups.com...
Chip - what do the two dashes mean before the MID function.
I've seen
this in some SUMPRODUCT formulas but don't understand the
significance.
Thanks
- John Michl