Most of us think in decimal, and computers mostly think in binary. Real numbers (numbers with decimal points) have a special format that they are stored in. Most decimal numbers can't be stored exactly in binary, that's why you get .9999... This is especially true when doing subtractions of numbers close to each other in value. Unfortunately, you are stuck with the ROUND function or something similar, or you may even save the value as text.
Lewis
Bookmarks