In article ,
Scott Summerlin wrote:

What I didn't get, but you explained it, is that the "--" converted
the text to numeric arrays.

For an explanation of how, see

http://www.mcgimpsey.com/excel/doubleneg.html