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 vote183 views1 answer
Supprimer la valeur de celule vba
VBA
3 votes185 views1 answer
Vba folderexists
VBA
1 vote180 views1 answer
Excel vba saveas force overwrite
VBA
0 vote187 views1 answer
Afficher un message d'erreur vba
VBA
5 votes202 views1 answer
Vba low byte from INTEGER
VBA
1 vote189 views1 answer
VBA Loop through recordset
VBA
0 vote177 views1 answer
Vb streamreader
VBA
0 vote174 views1 answer
Vba line feed
VBA
0 vote185 views1 answer
Vba full date format
VBA
0 vote189 views1 answer
Vba add shape oval
VBA