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 vote211 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote216 views1 answer
Vba min
VBA
0 vote229 views1 answer
Excel filter by date not working vba
VBA
0 vote229 views1 answer
Iterate all file in a folder vba
VBA
0 vote201 views1 answer
Add items to combobox vb.net
VBA
2 votes223 views1 answer
Excel vba extract file name
VBA
5 votes237 views1 answer
Excel vba get user selected range
VBA
0 vote237 views1 answer
Vba code for cutoff time
VBA
0 vote226 views1 answer
How to make a a msgbpx in vbs
VBA
3 votes230 views1 answer
Excel insert blank row for value change in column
VBA