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 vote325 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote297 views1 answer
Refresh token em vb net
VBA
0 vote330 views1 answer
Excel vba urlmon
VBA
9 votes450 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote340 views1 answer
Tester si une case est vide vba
VBA
0 vote306 views1 answer
Vba remove numbers from string
VBA
0 vote334 views3 answers
Write to text file vb.net
VBA
5 votes295 views1 answer
Vba array worksheet.index
VBA
4 votes312 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote331 views1 answer
How to enter Vbox manage commands
VBA