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 vote242 views1 answer
Vba loop through textboxes
VBA
0 vote193 views1 answer
Vba code to remove leading and trailing spaces
VBA
1 vote245 views1 answer
How to remove zeros in excel
VBA
0 vote237 views1 answer
Vba sheet visible
VBA
0 vote233 views1 answer
Vbscript abs
VBA
1 vote240 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote245 views1 answer
Arq linux
VBA
0 vote238 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote233 views1 answer
Remove last 8 characters from string vb
VBA
0 vote221 views1 answer
Style percent not found vba
VBA