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 vote122 views1 answer
Vba select file in folder
VBA
0 vote188 views1 answer
Vba extract filename from path
VBA
6 votes188 views1 answer
Excel vba get the path of current workbook
VBA
0 vote193 views4 answers
Vgrive,deb
VBA
0 vote185 views1 answer
Convert number to minutes in vba
VBA
0 vote195 views1 answer
Vbscript Trim
VBA
0 vote179 views1 answer
Show unix time in vba
VBA
0 vote180 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote175 views1 answer
Limit combobox to list vba
VBA
0 vote175 views1 answer
Vbs send keys
VBA