Easy Macro for Formatting Currency

In Excel, the default Currency ($ USD) setting is with the dollar sign and two decimal places.  As a personal preference, I remove the dollar sign and take the decimals down to 0 places.  Here is a quick macro in Visual Basic that will do both at once:

Sub Format_Currency_NoCents()
 Selection.NumberFormat = "#,##0"
End Sub

Alternatively, I have one that removes the $, and has two decimal places:

Sub Format_Currency()
 Selection.NumberFormat = "#,##0.00"
End Sub

Feel free to paste these into VB.

Leave a Reply

Your email address will not be published. Required fields are marked *