Hi,

I am puzzled by the fact that VBA append a # at the end of my programming
statement.

Dim val as Double

val = 0.5 + 10000000000# <- the # appended by VBA after the 10th zero (the
11th digit)

however

val = 0.5 + 1000000000 <- no problem if only contain 9 zeros (10 digits)

thank you