perhaps you could give some examples of the data where isnumber does not work

you have D8 contains a dash - or text or numbers

can we see the ISNUMBER formula you used in your string as well