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 vote323 views2 answers
Excel vba prevent save
VBA
0 vote344 views1 answer
Vba html document reference
VBA
0 vote351 views2 answers
Get unique random number in vb.net
VBA
0 vote295 views1 answer
How to self delete a vbscript file
VBA
0 vote332 views1 answer
Search in richtextbox vb.net
VBA
6 votes373 views1 answer
Excel vba isalpha
VBA
0 vote367 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote369 views1 answer
Sort dictionary by key vba
VBA
0 vote324 views1 answer
Vba code to select image in sheet
VBA
0 vote341 views1 answer
Vba compare strings
VBA