Format Cells in The General (default) Format in Excel Number Formatting
This free Excel macro formats a selected cell or range of cells to the General number format in Excel. This is the default number format and contains no special or specific formatting.
This is a great macro when you need to remove special number formatting from a large selection of cells quickly. This macro allows you to see exactly what is entered into the cell in Excel instead of a pre-formatted value.
Where to install the macro: Module
Excel Macro to Format Cells in The General (default) Format in Excel Number Formatting
Sub Format_Cell_General()
Selection.NumberFormat = "General"
End Sub
Subscribe for Weekly Tutorials
Helpful tutorials delivered to your email!
Similar Content on TeachExcel
Format Cells in The Short Date Number Format in Excel
Macro: This free Excel macro applies the Short Date number format to a selection of cells in Exce...
Macro: This free Excel macro applies the Short Date number format to a selection of cells in Exce...
Format Cells in The Long Date Number Format in Excel
Macro: This free Excel macro formats a selection of cells in the Long Date number format in Excel...
Macro: This free Excel macro formats a selection of cells in the Long Date number format in Excel...
Run a Macro when a User Does Something in the Worksheet in Excel
Tutorial: How to run a macro when a user does something in the worksheet, everything from selecting ...
Tutorial: How to run a macro when a user does something in the worksheet, everything from selecting ...
Run a Macro when a User Does Something in the Workbook in Excel
Tutorial: How to run a macro when a user does something within the Workbook in Excel, such as openi...
Tutorial: How to run a macro when a user does something within the Workbook in Excel, such as openi...
Automatically Lock Certain Cells in Excel using a Macro
Tutorial: This macro allows you to have a cell automatically locked after a user enters something in...
Tutorial: This macro allows you to have a cell automatically locked after a user enters something in...
Select Cells in Excel using Macros and VBA
Tutorial: This is actually a very easy thing to do and only requires a couple lines of code. Below I...
Tutorial: This is actually a very easy thing to do and only requires a couple lines of code. Below I...
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.