How to get the final digit before a decimal place in VBA.

[LightArisen]

Hello, I am creating a script that will gather several numbers and add them together. In cases where decimal numbers on large values lead to the number being incorrect e.g. 1,000,000,000.499 + 1,000,000,000.499 = 2000000001 displays as 1,000,000,000 + 1,000,000,000 = 2,000,000,001 I would like the script to go back and erase the decimal values and simply increment the first number to match the equation.

 

[jkpieterse]

What do you have so far? Excel should be able to add those numbers without a hitch.