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 vote81 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote154 views1 answer
Winforms dark title bar
VBA
5 votes149 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote130 views1 answer
WGET FTP
VBA
3 votes155 views2 answers
Vba date to string
VBA
0 vote117 views1 answer
Afficher un message d'erreur vba
VBA
1 vote131 views2 answers
Vba string length
VBA
1 vote111 views1 answer
How to do error handling in access vba
VBA
1 vote122 views1 answer
Excel vba compare 2 rows
VBA
0 vote126 views1 answer
Excel vba disable keyboard input
VBA