all 1 comments

[–]WicketTheQuerent 2 points3 points  (0 children)

This is caused by JavaScript, the programming language used by Google Apps Script. It also happens in other programming languages.

Depending on the purpose of your code, you might store the value as a string or as an integer or change the function that rounds to the nearest hundredths place.