Format money as $##,##0.00 : Currency Format « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. Currency Format

Format money as $##,##0.00

 

Sub formatMoney()
    MsgBox "Pay is:   " & Format(12345.67, "$##,##0.00"), , "Total Pay"
End Sub








Related examples in the same category

1.Format value as currency
2.formatted proper currency format ("$###.##")