Formatting cells from internet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Back
Top