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

22 votes547 views1 answer
Xl vba check for folder
VBA
0 vote284 views1 answer
Excel vba linter
VBA
0 vote331 views1 answer
Show unix time in vba
VBA
0 vote329 views1 answer
Internet explorer reference vba
VBA
0 vote365 views1 answer
Regex numeric digits
VBA
0 vote348 views1 answer
Excel filter by date not working vba
VBA
0 vote334 views1 answer
VB get external IP address
VBA
0 vote358 views1 answer
Excel vba protect shapes
VBA
1 vote331 views1 answer
Excel vba unload userform
VBA
0 vote323 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA