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 vote248 views1 answer
VBA
VBA
0 vote211 views1 answer
Excel vba join variant array
VBA
1 vote247 views1 answer
Vb.net get name by Cell Click
VBA
0 vote226 views1 answer
Date as number vb
VBA
0 vote207 views1 answer
Vba copy paste value only
VBA
0 vote222 views1 answer
Vba sort the data Z to A
VBA
0 vote211 views1 answer
Excel vba disable copy paste
VBA
0 vote212 views1 answer
Excel vba remove formatting from cell
VBA
0 vote235 views1 answer
Vbs run with cscript
VBA
0 vote220 views1 answer
Vb streamreader
VBA