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 vote155 views1 answer
Excel vba disable screen update
VBA
0 vote176 views1 answer
Write listbox to text file vb.net
VBA
15 votes241 views1 answer
Excel vba wait
VBA
1 vote182 views1 answer
Vba format string as cash
VBA
0 vote180 views1 answer
Excel last used row
VBA
0 vote176 views1 answer
Vba listbox remove all items
VBA
3 votes179 views1 answer
Vba double quote
VBA
0 vote170 views1 answer
Vba apostrophe chr
VBA
3 votes182 views1 answer
Vba continue for each loop
VBA
0 vote173 views1 answer
Vbnet convert charatcer to binary
VBA