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