Format Cells as a Currency in Excel Number Formatting
This free Excel macro allows you to quickly and easily format a selection of cells in the Currency number format in Excel. This format allows you to display a number as a currency so that readers immediately know that a number is a currency and exactly what currency it is.
This macro is made to display a number in the U.S. dollar currency format but can be easily changed for any currency.
Where to install the macro: Module
Macro to Format Cells as a Currency in Excel Number Formatting
Sub Format_Cell_Currency_US_Dollar()
Selection.NumberFormat = "$#,##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.)
Macro: This free Excel macro formats a selection of cells as a Percentage in Excel. This simply c...
Macro: This free Excel macro will automatically format a selected cell or many selected cells in ...
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Macro: This free Excel macro will highlight every other row in a selection of cells with a color ...
Tutorial: How to quickly delete all empty cells or rows from a range in Excel. This allows you to ...
Macro: This free Excel macro formats a selected cell as an Accounting number. This means that the...
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.
Macro: This free Excel macro formats a selection of cells as a Percentage in Excel. This simply c...
Macro: This free Excel macro will automatically format a selected cell or many selected cells in ...
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
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.)