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 vote171 views10 answers
Vba excel create event log
VBA
0 vote259 views1 answer
Excel vba urlmon
VBA
8 votes255 views1 answer
Excel vba make integer
VBA
0 vote274 views2 answers
Excel vba number format file size
VBA
0 vote279 views1 answer
Programmatically copy data from one workshet to another excel
VBA
15 votes292 views1 answer
Excel vba wait
VBA
0 vote234 views1 answer
Putting marquee in vb.net
VBA
0 vote288 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote215 views1 answer
Vbide vbproject reference
VBA
0 vote269 views1 answer
Vba ternary
VBA