Currency - The number is displayed with two decimal places, a thousand separator, and the currency symbol appropriate to the system locale.

 
Sub formatDemo3()
    Debug.Print Format("12345", "Currency")
End Sub

1.	General Number - The number is displayed with no thousand separator.
2.	Fixed - The number is displayed with two decimal places and at least one integer place.
3.	Standard - The number is displayed with two decimal places, at least one integer place, and a thousand separator (when needed).
4.	Percent - The number is displayed multiplied by 100, with two decimal places, and with a percent sign.
5.	Scientific - The number is displayed in scientific notation.
6.	Yes/No - A non-zero number is displayed as Yes; a zero number is displayed as No.
7.	True/False - A non-zero number is displayed as True; a zero number is displayed as False.
8.	On/Off - A non-zero number is displayed as On; a zero number is displayed as Off.
9.	Format(dblNumber "0.00")
10.	Format(dblNumber "000000.00")
11.	Format(dblNumber "#####0")
12.	Format(dblNumber "###,##0.00"): double
13.	Characters for Creating Your Own Number Formats
14.	returns a currency formatted with four decimal places:

Currency - The number is displayed with two decimal places, a thousand separator, and the currency symbol appropriate to the system locale. : Number Format « Date Functions « VBA / Excel / Access / Word