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!