OK I found a quick solution for those who comes across this issue.

Needs to cast the field as BIGINT then use FLOAT to remove the decimal to get the actual...

I did that already. I even changed the field to varchar(100) with no success.