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 vote113 views1 answer
Search in richtextbox vb.net
VBA
0 vote105 views1 answer
Vb net dgv doesn't keep currency format
VBA
5 votes120 views1 answer
Excel vba tool to help with refactoring code
VBA
1 vote100 views1 answer
If inputbox cancel vba
VBA
0 vote107 views1 answer
Vba sort the data Z to A
VBA
0 vote107 views1 answer
Arq linux
VBA
0 vote103 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote100 views1 answer
Compare dates vb
VBA
2 votes102 views1 answer
Date format for ms chart vb.net
VBA
0 vote102 views1 answer
Internet explorer reference vba
VBA