check if double/float

Hello Pabs,

All numbers on a worksheet are stored as Double data type (IEEE 64 bit double precision floating point). Formatting only changes the appearance of the number, not the stored number itself. The internal precision is carried out to 15 decimal places.

If you need to check a variable in VBA then you need to first assign the number to a Variant data type variable. You can then use the VBA function VarType to determine if the number is Double. If the return value is 5, it is a double number.