Excel VBA Type Conversion Functions

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL| More Free Downloads.. Best Value: Finance Templates Bundle

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 orConvert 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. ALLpurchases 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

Try out:Analyzer XL |Downloader XL |Smart VBA |Trader XL Pro (best value) |ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader PackageTechnical 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