Formatting cells from internet

A

A. S.

I have copied and pasted a chart from a website. (The website will not let me import) The cells are showing numbered values, but when i go to put the formula in it is giving me a zero like it cannot read the numbers in the cell. That is on 3 seperate columns. On the very last column it is reading the numbers

I cannot make it recognize that those columns are numbers to be used in formulas

Thanks for your help!
 
K

Ken Wright

Use Dave McRitchie's Trimall macro to clean up the data. Then copy an empty
cell, select all your data and do Edit / PasteSpecial / Add and it will coerce
all data back to numeric.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



A. S. said:
I have copied and pasted a chart from a website. (The website will not let me
Click to expand...
import) The cells are showing numbered values, but when i go to put the formula
in it is giving me a zero like it cannot read the numbers in the cell. That is
on 3 seperate columns. On the very last column it is reading the numbers.
 
Top