Missing thousand / million units from number when Query Result from Google Sheet

I imported a data source from Google Sheet. Everything worked fine!

But when I tried to query result from google sheet, the number behaved weirdly.
I want to divide a column with a specific number however:

1,000,000 suddenly became 1.
108,000 suddenly became 108
in my calculation.

Could any one help please. Thanks