Number not ZERO 0 ???? 1.13686837721616E-13

[HotNumbers]

I am at a lost. In number format the number appears are ZERO 0 However, when i change format to GENERAL it appears as 1.13686837721616E-13 ANY Idea on how i CAN correct this via VB? for data i have in COLUMN P10:P50,000

 

[Tom Urtis]

Sounds like a typical instance of floating point arithmetic only allowing for 15 decimals of precision in VBA. Some calculations will have a different visual result than actual result when produced by computers and/or programming languages like VBA when the results go beyond a computer's calculation capacity for lengthy decimals or very large numbers.