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 vote188 views1 answer
Vba first line of string
VBA
3 votes213 views1 answer
Extract word in a text in excel
VBA
0 vote177 views1 answer
Vba copy paste value only
VBA
2 votes181 views1 answer
Excel vba date to string conversion
VBA
0 vote189 views1 answer
Refresh token em vb net
VBA
0 vote184 views1 answer
Vba dropdown event
VBA
0 vote195 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote188 views1 answer
Excel vba linter
VBA
0 vote175 views1 answer
Vba add shape oval
VBA
3 votes204 views1 answer
Excel vba make long from two shorts
VBA