Format Cells as Text in Excel
This free Excel macro formats a selection of cells as Text in Excel. This macro applies the Text number format to cells in Excel. This means that all contents of a cell are treated as text and, though you can display numbers in the same cells, text is formatted to align to the left of a cell. This means that numbers with text formatting will appear on the left side of a cell.
Where to install the macro: Module
Excel Macro to Format Cells as Text in Excel
Sub Format_Cell_Text()
Selection.NumberFormat = "@"
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 in the Time format in Excel. This Time ...
Tutorial: How to put dynamic formatted dates and numbers into text in Excel. This allows you to hav...
Tutorial: How to quickly and easily remove all HTML from data copied into Excel. This tutorial inclu...
Tutorial: How to count cells that match text at the start or the end of a string in Excel. If you w...
Macro: This free Excel macro formats a selection of cells as a Percentage in Excel. This simply c...
Macro: This free Excel macro allows you to quickly and easily format a selection of cells in 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 in the Time format in Excel. This Time ...
Tutorial: How to put dynamic formatted dates and numbers into text in Excel. This allows you to hav...
Tutorial: How to quickly and easily remove all HTML from data copied into Excel. This tutorial inclu...
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.)