Convert to Double .
-1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324
to 1.79769313486232E308 for positive values
Convert to Decimal .
+/-79,228,162,514,264,337,593,543,950,335 for zero-scaled numbers, that
is, numbers with no decimal places. For numbers with 28 decimal places, the
range is +/-7.9228162514264337593543950335. The smallest possible non-zero number
is 0.0000000000000000000000000001
Convert to Long . -2,147,483,648
to 2,147,483,647; fractions are rounded.
Convert to Single .
-3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38
for positive values
Convert to String .
Returns for CStr depend on the expression argument... Boolean = A
string containing True or False. Date = A string containing a date in
the short date format of your system. Null = A run-time error. Empty
= A zero-length string (""). Error = A string containing the word Error
followed by the error number. Other numeric = A string containing the
number
Convert to Variant .
Same range as Double for numerics. Same range as String for
non-numerics.
Excel Online