|Glad I could help.|
re: "I had mistyped the formula in the post..."
I often suggest that formulas be copied directly from the formula bar and pasted into a post instead of re-typing them. For one thing, why bother? Copy...Paste is so much easier. More importantly, the exact formula that is giving you problems will be in the post with no possibility of a typo.
Just as an aside, if you are ever stuck with a list of "text numbers" that won't act like numbers in Excel, you can try a few things to convert them to numbers.
Many times, performing any type of mathematical operation on the text will convert it to a number.
For example, if you Copy an empty cell and then do a PasteSpecial...Add to your text cells, it will try to add 0 to the "text" and convert it to a number.
Of course, that wouldn't have worked in your case since the text was the result of a formula, but often times "numbers" that are download from the web or copied from another app often end up as text and you can't do anything with them until they are converted to numbers.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.