Try a seperate column for each column of numbers you want to see, using the VALUE() function. i.e. if you have numbers in column A that Excel is treating as text, and you want them as numbers, insert a new column and put =VALUE(A1) in the first cell of the new column. You can then fill down, and the new column will pick up the numeric value.