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 vote168 views1 answer
VB get external IP address
VBA
0 vote167 views1 answer
Vbnet hex to binary
VBA
1 vote159 views1 answer
How to do error handling in access vba
VBA
0 vote185 views1 answer
Excel vba textbox forecolor disabled
VBA
5 votes170 views1 answer
Excel vba high word from Long Integer
VBA
0 vote174 views1 answer
Excel vba StartUpPosition
VBA
0 vote176 views1 answer
Vba code for cutoff time
VBA
1 vote180 views1 answer
Excel vba autofit
VBA
1 vote167 views1 answer
Vba ubound array 2-dimensional
VBA
3 votes164 views1 answer
Vba not equal
VBA