Format Cells as an Accounting Number in Excel Number Formatting
This free Excel macro formats a selected cell as an Accounting number. This means that the accounting number format is applied to any cells that have been selected when this macro is run. This format puts a dollar sign in the left and by default adds two decimal places to the number. This format is meant to display money.
This is a great piece of code to include by itself or in a larger macro in order to speed up formatting in Excel.
Where to install the macro: Module
Excel Macro to Format Cells as an Accounting Number in Excel Number Formatting
Sub Format_Cell_Accounting()
Selection.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)"
End Sub
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel. This situat...
Macro: This free Excel macro formats selected cells in the Scientific number format in Excel. Thi...
Macro: This free Excel macro will automatically format a selected cell or many selected cells in ...
Tutorial: How to convert scientific numbers to show their full amount; this method also allows you ...
Tutorial: I'll show you 2 ways to add and keep leading zeros in front of numbers in Excel. These t...
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...
How to Install the Macro
- Select and copy the text from within the grey box above.
- Open the Microsoft Excel file in which you would like the Macro to function.
- Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.
Or For other ways to get there, Click Here.
- On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.
- If the Macro goes in a Module, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.
- Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.
- You are now ready to run the macro.
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel. This situat...
Macro: This free Excel macro formats selected cells in the Scientific number format in Excel. Thi...
Macro: This free Excel macro will automatically format a selected cell or many selected cells in ...
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)