Format value as currency : Currency Format « Data Type « VBA / Excel / Access / Word

1.	Access
2.	Application
3.	Data Type
4.	Data Type Functions
5.	Date Functions
6.	Excel
7.	File Path
8.	Forms
9.	Language Basics
10.	Math Functions
11.	Outlook
12.	PowerPoint
13.	String Functions
14.	Windows API
15.	Word
16.	XML

VBA / Excel / Access / Word » Data Type » Currency Format

Format value as currency

 

Sub CCurDemo()

    Dim hours

    Dim hourlyPay

    Dim payPerWeek

    hours = 40

    hourlyPay = 20

    payPerWeek = CCur(hours * hourlyPay)

    MsgBox "Pay is:   " & Format(payPerWeek, "$##,##0.00"), , "Total Pay"



End Sub

Related examples in the same category

1.	formatted proper currency format ("$###.##")
2.	Format money as $##,##0.00

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.