Excel VBA Video Training/ EXCEL DASHBOARD REPORTS

Excel VBA Type Conversion Functions

Excel VBA Type Conversion Functions. Convert Numbers to Text & Text to Numbers

Got any Excel Questions? Free Excel Help

These Excel VBA conversion functions can be use to convert a text string to a true number and a true number to a text string.

Convert to Boolean . TRUE or FALSE Any valid string or numeric expression
Convert to Byte . Whole Number from 0 to 255
Convert to Currency . Numeric amount from 922,337,203,685,477.5808 to 922,337,203,685,477.5807. See Also: Convert a Numeric Value into English Words or Convert a Currency or Value into English Words
Convert to Date . Any valid date expression
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 Integer . -32,768 to 32,767; fractions are rounded.
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 Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software

Excel VBA Video Training/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft