I NEED A GENIUS

  • Thread starter Thread starter Inept
  • Start date Start date
I

Inept

OK Excel Geniuses - show me what you're made of!!
Can anyone answer this: When i paste in info from a web
site, one of the columns contains numbers, yet when I try
to refer to those numbers in formulas in other cells, it
always comes up with the #VALUE! message, as though it
were text in there, not numbers. Any ideas?
 
Copy a blank cell. Select your "numbers". Format them as General or
another Number format. Choose Edit/Paste Special, selecting the
Values and Add radio buttons. Click OK. This coerces text to numbers.
 
If this is something you are going to do regularly, then put a copy of Dave McRitchie's Trimall
macro into your personal.xls and run it against your data every time you do this. That will clear
out the garbage, and you can then follow Dave P & JEs advice re copying an empty cell, selecting
your range of data and then doing Edit / Paste Special / Add which will coerce any textual data
back to numeric.

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