Excel vba change format of cell

'VBA code to change the Number Formatting of a cell range:

[A1].NumberFormat = "@"

'There are hundreds of options for Number Formats. The above sets
'cell A1 to display as Text.

Here are a few other Number Formats:

[A1].NumberFormat = "General"
[A1].NumberFormat = "$#,##0.00"
[A1].NumberFormat = "mm-dd-yyyy"

Source: academy.excelhero.com

Similar codes

0 vote240 views1 answer
Find the name of the last excel sheet vb
VBA
5 votes148 views1 answer
Excel formula how to create strings containing double quotes
VBA
8 votes197 views1 answer
Excel vba make word
VBA
1 vote154 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
4 votes142 views1 answer
Excel vba check cell not empty
VBA
1 vote177 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote155 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote154 views1 answer
.net dark title bar
VBA
8 votes170 views1 answer
Run command pormpt in background windows
VBA
0 vote153 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA