Excel 2007 - Convert text to numbers

G

Glenda

I am copying data into a worksheet from another program. Excel sees the
numbers as text and I get an error message.
I would like to highlight the entire worksheet ( via clicking on the area
between the A and the 1 in the cell/row identifier upper left corner) and
change all of the data to numbers. It doesn't work.

The only method I've found to do this conversion is by actually clicking on
the error warning box - this method doesn't work in a macro. Is there
another way?

Does anyone have other suggestions for doing this?
 
P

Peo Sjoblom

I usually select the imported column, make sure it if not formatted as text
and then do data>text to columns and when the import wizard opens I just
press finish. That usually works. But I guess it depends on if you have some
extra character baggage from the other program like invisible trailing html
characters (CHAR(160)

--


Regards,


Peo Sjoblom
 
G

Glenda

I am inputting data from a CMM file I don't have any idea how to change the
file method in the CMM program.

Do you know how to change the format of the worksheet so all files are a
number?

thanks again
 
G

Glenda

I found a method in the Excel Help,
enter the number 1 in a cell
copy the cell
paste special the cell
choose multiply times the cell

The answers to these kinds of things are so easy, once discovered, thanks
for your help
 
Top