Formula problems relating to Format

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

Guest

I copied a list of numbers from an on-line database. Everything looks legit,
I even converted all formats to Numbers, but when I apply the math functions
(e.g. Sum or Avg), I get zero or errors. I believe this has to do with
formating - a friend of mine got one column to temporarily work after going
somewhere and clicking "convert", but promptly forgot how she did it. On the
other hand, if I hand-type these numbers in, and do the function, everything
works fine. It is only with the numbers I pasted it (and doing paste special
values doesn't help).

What a mystery -- help!
 
First get rid of any blanks or chr(160)'s in your data using find/replace.
Second enter 1 in an un-used cell, copy that cell, and then
paste/special/multply
on top of your data.

This should make them "real" numbers.
 
WOW, that's AWESOME! I had the same problem and this worked like a charm!!
Thanks!!
 
Back
Top