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

8 votes381 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote328 views1 answer
Find if year is leap year vb
VBA
0 vote315 views1 answer
Excel text to columns line break
VBA
0 vote323 views1 answer
Excel vba send HTTP POST to server
VBA
20 votes451 views1 answer
Excel vba factorial
VBA
5 votes324 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote288 views1 answer
Vb test if reference is null
VBA
0 vote311 views1 answer
Ribbon show/hide
VBA
0 vote303 views1 answer
Get current url vb.net
VBA
0 vote329 views1 answer
Excel vba urlmon
VBA