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 vote161 views1 answer
Excel vba linter
VBA
0 vote160 views1 answer
Menus act like radio buttons vb.net
VBA
18 votes300 views3 answers
Excel-vba make integer
VBA
0 vote166 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote184 views1 answer
Create new worksheet excel visual basic
VBA
0 vote160 views1 answer
Excel R1C1 mode
VBA
1 vote158 views1 answer
Excel vba first and last row and column in range
VBA
2 votes155 views1 answer
Excel vba check if key is in collection
VBA
0 vote157 views1 answer
Vba shape transparent
VBA
0 vote166 views1 answer
Vba simple quote
VBA