VBA Function returns wrong value

Question

Hi,

My number is

2,495,159,565.00

in VBA I am converting it with the function Fix or Int. It returns as

2,495,159,564

Please see the video...

Sample Video

Answer 1

Hi Umut

Please, make sure that the variables iVal and num_entry are correctly Dimentioned

i.e.

Dim iVal As Double

Dim num_entry as Double

OR

Dim iVal As LongLong

Dim num_entry as Double

For more info please, check the links below

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/double-data-type https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/longlong-data-type

Regards

Jeovany

Answer 2

Hi Jeovany,

Thank you for the fast reply.

Actually, I had the Dimentioned without "as Double" part. Then, I tried "num_entry as Integer", it didnt work and then I tried "as Double" and worked like a charm.

Option Explicit

Dim iVal As Double
Dim num_entry As Double