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

1 vote213 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote230 views1 answer
Vba format currency
VBA
0 vote227 views1 answer
Excel named range sum
VBA
2 votes166 views2 answers
Vba exit loop
VBA
0 vote250 views1 answer
Vbscript Trim
VBA
1 vote230 views1 answer
Excel vba get column number from column name
VBA
0 vote250 views1 answer
Group controls programmatically vb
VBA
5 votes238 views1 answer
Excel vba second byte from INTEGER
VBA
1 vote238 views1 answer
Set font for ms chart vb.net
VBA
0 vote230 views1 answer
Discern between file and folder given path vb.net
VBA