I have a series of numbers that although they look like numbers and are formatted as numbers are not numbers they are something else. I have tried text to columns but something weird is occurring so the question is as follows: can someone work out a simple formula that will count text as a number and return the highest and the lowest number.
Bookmarks