Excel VBA Video Training/ EXCEL DASHBOARD REPORTS

Convert to a Currency Data Type

Got any Excel Questions? Free Excel Help . Back To: All Conversion Functions . Back to Excel VBA

The example below shows how CCur can be used in Excel VBA to convert a number to a Currency data type. 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

Sub ConvertToCurrency()

Dim lNum As Double



lNum = 999.989876

MsgBox CCur(lNum)



End Sub

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