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

8 votes281 views1 answer
Vba make a short integer from two bytes
VBA
0 vote214 views1 answer
Vbnet add new ecel sheet
VBA
5 votes242 views1 answer
Vba low word from Long Integer
VBA
0 vote231 views1 answer
Vba variable number of arguments
VBA
0 vote240 views1 answer
Excel vba protect worksheet without password
VBA
0 vote241 views1 answer
Prive sub enter clicked vb
VBA
0 vote219 views1 answer
Vba argument is set
VBA
0 vote243 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote241 views1 answer
Vbnet hex to binary
VBA
0 vote223 views1 answer
Vba code to open a file with login rights
VBA