data format
 

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

data format
 

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

data format
 

To add to Tyro's post,

When you copy from the web you often
get a lot of non-breaking spaces (google for an explanation)

To get rid of them go to EditReplace
Replace what: Alt+0160
Replace with: Leave this box blank
Click Replace all

To type unicode
Hold down the Alt Key
Type 0160 (on the number pad only)
Let go of the Alt key

HTH
Martin

"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

data format
 

One thing to try in addition to the other suggestions.

Could be numbers are really text so calculations won't take place.

Format all to General then copy an empty cell.

Select the data and EditPaste Special(in place)AddOKEsc


Gord Dibben MS Excel MVP


On Fri, 1 Feb 2008 16:40:00 -0800, joec wrote:

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.