Hi!

Both RIGHT and SUBSTITUTE are TEXT functions. The values they return are
TEXT.

The -- "converts" the text numbers into numeric numbers.

Biff

"RichK" wrote in message
oups.com...
Thanks for your answer.

I knew someone would have an elegant solution!

What does the double dashes in front of the SUBSTITUTE function
accomplish?

I get everything else.

Thanks again.

--Rich K.