On Fri, 22 Feb 2008 19:52:00 -0800, Wayne
wrote:



"Gord Dibben" wrote:

You cannot reference more than one cell with Gord's sumnums UDF or Ron's
evalnums.

Ron's evalnums is inconsistent with the Summing as far as I have tested.

With 2C + 4T =evalnums(cellref) returns 6 which is correct.

While 2CT + 123Y returns 125....2 + 123

=sumnums(cellref) returns 8..........2 + 1 + 2 + 3

Which of these would be considered appropriate?

Both of those would be.. but let me state that it will never be more that 2
digits and 1 letter in any one cell

I don't think a computer can deal with having two different correct answers to

2CT + 123Y

--ron