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 vote385 views1 answer
Vba add shape oval
VBA
22 votes583 views1 answer
Xl vba check for folder
VBA
4 votes381 views2 answers
Vba last row
VBA
0 vote355 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote399 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote373 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote353 views1 answer
Vba len variant
VBA
4 votes376 views2 answers
Excel vba last column with data
VBA
3 votes349 views1 answer
Vba folderexists
VBA
0 vote390 views1 answer
Loop through lines in text file vb net
VBA