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 vote256 views1 answer
How to call gcd in vba
VBA
0 vote208 views1 answer
Sendkeys vba selenium
VBA
2 votes210 views1 answer
Vba split string
VBA
0 vote216 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote208 views1 answer
Vba change named range address
VBA
2 votes209 views2 answers
Vba code to remove duplicates from a column
VBA
-1 vote215 views2 answers
Excel vba delete empty rows
VBA
0 vote205 views1 answer
Vbnet line chart showing extra space
VBA
0 vote204 views1 answer
Vbs
VBA
1 vote246 views1 answer
Perform http request in vb.net
VBA