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.