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

22 votes500 views1 answer
Xlvba check for folder
VBA
0 vote334 views1 answer
Set column width of datagridview vb.net
VBA
0 vote363 views2 answers
Open url from vba
VBA
5 votes375 views1 answer
Vba low word from Long Integer
VBA
0 vote353 views1 answer
Vba static variable
VBA
0 vote353 views1 answer
Excel vba protect content
VBA
-1 vote313 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
3 votes371 views1 answer
Vba make long from two words
VBA
0 vote348 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote372 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA