I'm not sure what you mean by "The data goes into separate cells". One word
per cell, one number per cell, one sentence per cell?
You may have text numbers in your cells, not numerics. They appear as left
justified numbers. You can convert the text numbers to numeric. An easy way
is to copy a 0 (zero) from a cell and paste special, operation, add. That
will add 0 to the text numbers and change them to numeric.

Tyro

"joec" wrote in message
...
Is there any way to convert data that excel is not recognizing so that it
is
in a uable form? For example if I copy data from a web report into excel.
The
data goes into separate cells as it should but when I try to run a formula
on
the data excel will not recognize the data. I tried running the text to
columns function.
--
joec