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

6 votes162 views1 answer
Excel vba isalpha
VBA
2 votes99 views1 answer
Excel vba pause
VBA
5 votes153 views1 answer
Excel vba low word from Long Integer
VBA
1 vote139 views1 answer
Vba reverse string
VBA
0 vote190 views1 answer
Vba excel do not recalculate before save
VBA
0 vote155 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote145 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote134 views1 answer
Add Formula to Shape Text in VBA
VBA
2 votes152 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote144 views1 answer
Excel vba assign shortcut key to button
VBA