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

15 votes421 views1 answer
Excel vba wait
VBA
0 vote229 views1 answer
Excel vba move down to next visible cell
VBA
3 votes235 views1 answer
Extract word in a text in excel
VBA
-1 vote203 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote217 views1 answer
Vbnet chart make 0 gridline line different color
VBA
7 votes221 views1 answer
Excerl vba array to range
VBA
0 vote207 views1 answer
Vba open report
VBA
0 vote238 views1 answer
Set datetimepicker value to null vb
VBA
0 vote252 views1 answer
Excel vba protect worksheet without password
VBA
0 vote203 views1 answer
Excel vba StartUpPosition
VBA