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

4 votes139 views2 answers
Vba create folder if not exist
VBA
0 vote147 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote147 views1 answer
Default host vbox address
VBA
0 vote133 views1 answer
Excel vba disable copy paste
VBA
8 votes257 views1 answer
Vba make a short integer from two bytes
VBA
0 vote141 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
1 vote141 views1 answer
Excel vba first and last row and column in range
VBA
2 votes129 views1 answer
Vba uppercase first letter of each word
VBA
0 vote136 views1 answer
Vba array of integers
VBA
0 vote94 views10 answers
Vba excel create event log
VBA