Ozgrid, Experts in Microsoft Excel Spreadsheets

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.

  1. Convert to Boolean . TRUE or FALSE Any valid string or numeric expression
  2. Convert to Byte . Whole Number from 0 to 255
  3. 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
  4. Convert to Date . Any valid date expression
  5. Convert to Double . -1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values
  6. 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
  7. Convert to Integer . -32,768 to 32,767; fractions are rounded.
  8. Convert to Long . -2,147,483,648 to 2,147,483,647; fractions are rounded.
  9. Convert to Single . -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values
  10. 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
  11. 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 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

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates