Excel extracted API data doesn't seem to be numbers

Posted on behalf of Bryan deSilva. Original posting date 2017-03-23.

I cannot use a pivot table. Everything is zero. Even if I format it manually. What's up with this? I'm using query in Excel using the API address as instructed in the API guide. The data comes, but isn't usable. What might I be doing wrong? I can manually add two numbers (=A1+B1), but I cannot =SUM(....) nor create a pivot table. Just zeros.