Checking if the number is decimal

[kpark91]

Hello, I come with another programming question D:

I've been trying to solve Problem 3 of Project Euler with VBA and because I'm still a learner in every programming aspects. If either of these two questions are answered, it would mean ALOT to me

In VBA or any programming languages, when we're using Mod, the numbers have to be low enough to actually perform the function. (and they also need to be integers).

However, my number is too high and it cannot be converted to integers because of overflow. (1) So, is there such a function in VBA that allows me to find the remainder between the two doubles?

As far as I'm concerned, VBA does not have it or any other programming languages. So, this leads to my second question.

(2) How do I check if a double is a decimal number?


Thank you in advance!
kpark

 

[shg]

From Help:

Int, Fix Functions

Returns the integer portion of a number.
Syntax
Int(number)
Fix(number)
The required number argument is a Double or any valid numeric expression. If number contains Null, Null is returned.

It returns the same data type (Byte, Integer, Long, Single, Double) as its argument, or a Double for a numeric string.

 

[GTO]

From Help:

It returns the same data type (Byte, Integer, Long, Single, Double) as its argument, or a Double for a numeric string.

Thank you very much

Mark