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 vote285 views1 answer
Vb get ip address
VBA
0 vote272 views1 answer
Excel vba protect content
VBA
2 votes292 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote285 views1 answer
Excel vba DisplayAlerts
VBA
0 vote293 views1 answer
Excel filter by date not working vba
VBA
1 vote278 views1 answer
Add rows to datagridview vb.net
VBA
0 vote301 views1 answer
Excel vba add reference programmatically
VBA
0 vote285 views1 answer
Vba simple quote
VBA
0 vote281 views1 answer
VBA Loop to range
VBA
0 vote259 views1 answer
Vba first line of string
VBA