Do you know how computers store floating-point numbers? The way it works is nobody's fault, but wishing it was other than it is, is futile.
As William Lu said, if you care about the sequence of characters that make up the number, not the numerical value, then you have to treat the number as a string.
Database
number field comma truncation
This discussion has been locked so you can no longer reply to it.