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

1 vote225 views1 answer
Excel vba make cell visible
VBA
0 vote226 views1 answer
Excel vba range contains
VBA
0 vote229 views1 answer
Vba shape transparent
VBA
2 votes235 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
3 votes302 views1 answer
Excel vba make long from two shorts
VBA
5 votes253 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote247 views1 answer
Delete all controls in an area vb
VBA
5 votes248 views1 answer
Excel vba right word from Long Integer
VBA
25 votes561 views3 answers
String to date vb
VBA
0 vote336 views1 answer
Find the name of the last excel sheet vb
VBA