Data Formats

  • Thread starter Thread starter Luis
  • Start date Start date
L

Luis

Hi,

I imported an ASCII file to excel and want to use the
correlation from the Data analysis pack. When I do it, I
get an error message that says:

Corelation- Input range contains non numeric data.

I already confirmed all the cells have the NUMBER format
and still get the same error.....

Any advice?

Thanks.
 
There must be a field with non-numeric data. Try this
method. Create a new column and multiply the input value by
one. Copy this output and paste the value using the paste
special and use the column for data analysis.
 
Hi

Your data were imported as text, and changing cell format doesn't change
data format automatically. Enter a number 1 somewhere into free cell, copy
it, select the range with data to convert to numbers, and then
PasteSpecial.Multiply. It multiplies all data in selected range with 1, thus
returning numeric values. And don't forget to erase the entered number from
worksheet afterwards.


Arvi Laanemets
 
Back
Top