Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

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

New & Less Than You Think: List Managers | Working With Excel Sheets In VBA | Excel Charting Lessons | Delete rows by condition | TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL | More Free Downloads.. Best Value: Finance Templates Bundle

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 special@ozgrid.com 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 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

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS