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 vote282 views1 answer
Vba full date format
VBA
0 vote243 views1 answer
How to self delete a vbscript file
VBA
0 vote298 views1 answer
Vba open report
VBA
0 vote291 views1 answer
Vbnet hex to binary
VBA
0 vote243 views1 answer
How to make a if statement with vbs
VBA
0 vote297 views4 answers
How to continue formula in below line in vba code
VBA
0 vote288 views1 answer
Excel vba textbox forecolor disabled
VBA
4 votes288 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote289 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote305 views1 answer
Remove last 8 characters from string vb
VBA