I had this same problem, but nothing I try will convert the "text" to
numbers. Any other ideas?

"dlw" wrote:

Yes, they were text, it was throwing me off, because in addition to adding
them, it also formatted this "text" as currency and numbers with 0 decimal
places.
(very coercive)

"dlw" wrote:

I copied some numbers from an Access query into an Excel 2000 spreadsheet.
When you sum them, it comes up 0, when you just add them, it works. For
example =(a1+a2) gives the right answer, =sum(a1.a2) gives 0.
What causes that?