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 vote181 views1 answer
How to make a a msgbpx in vbs
VBA
5 votes191 views1 answer
Vba low byte from INTEGER
VBA
0 vote168 views1 answer
Vbnet display all axis labels in cahrt
VBA
1 vote172 views1 answer
Excel vba force recalculation
VBA
0 vote202 views1 answer
Vbnet check if string is only letters
VBA
0 vote163 views1 answer
How to extract a file from an ISO:
VBA
9 votes228 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote180 views1 answer
Set column width of datagridview vb.net
VBA
0 vote187 views1 answer
Remove series name from legendvbnet
VBA
0 vote169 views1 answer
Loop through lines in text file vb net
VBA