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 vote359 views1 answer
Excel run macro every 5 minutes
VBA
0 vote380 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote350 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote337 views1 answer
Add Formula to Shape Text in VBA
VBA
1 vote371 views1 answer
Excel vba compare 2 rows
VBA
1 vote356 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote395 views1 answer
Excel delete ever other vba
VBA
0 vote396 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
31 votes500 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
5 votes419 views1 answer
Excel vba first byte from INTEGER
VBA