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 vote118 views1 answer
Find days in month vba
VBA
3 votes138 views1 answer
Vba post request json
VBA
0 vote127 views1 answer
Handling a click event anywhere inside a panel vb
VBA
-1 vote127 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote132 views1 answer
Excel vba cell on change
VBA
0 vote142 views1 answer
Vba paste values
VBA
0 vote133 views1 answer
Vbnet line chart showing extra space
VBA
0 vote137 views1 answer
Add text to combobox drop down vb
VBA
0 vote142 views1 answer
Vba exit while
VBA
0 vote128 views1 answer
Vba string
VBA