I have a file I exported from another program so that I can work with it and
the numbers export as text. I need to convert the text to numbers so that I
can count, sum, average, etc. I tried selecting and formatting to a variety
of different number formats and even copying and paste special as value and
number formats. Can anyone suggest a solution?