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 vote220 views1 answer
Excel vba remove formatting from cell
VBA
0 vote273 views1 answer
Wpf dark title bar
VBA
18 votes576 views2 answers
Vba make word from bytes
VBA
5 votes171 views1 answer
Vlookup vba
VBA
0 vote236 views1 answer
Excel vba Column Name from Column Number
VBA
2 votes173 views2 answers
Vba exit loop
VBA
0 vote218 views1 answer
Add items to combobox vb.net
VBA
2 votes217 views1 answer
Vba split string
VBA
1 vote178 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote229 views1 answer
Enter into cells data grid view
VBA