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 vote210 views1 answer
Docker vboxmanage not found
VBA
1 vote220 views1 answer
Add control vb
VBA
0 vote220 views1 answer
Excel protect cells with formulas
VBA
0 vote204 views1 answer
Vba apostrophe chr
VBA
0 vote207 views1 answer
Add Formula to Shape Text in VBA
VBA
1 vote244 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote220 views1 answer
Vba text to general
VBA
0 vote223 views1 answer
Vbs send keys
VBA
12 votes274 views1 answer
Excel vba write string to text file
VBA
1 vote230 views1 answer
Vb.net get name by Cell Click
VBA