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

3 votes345 views1 answer
Vba make long from two shorts
VBA
1 vote368 views1 answer
How to remove zeros in excel
VBA
3 votes342 views1 answer
Excel vba read registry key value
VBA
0 vote334 views1 answer
Excel vba disable alerts
VBA
2 votes340 views1 answer
Excel vba check if key is in collection
VBA
0 vote368 views1 answer
Excel vba protect worksheet without password
VBA
5 votes410 views1 answer
Vba low byte from INTEGER
VBA
3 votes406 views1 answer
Extract word in a text in excel
VBA
0 vote352 views1 answer
Vbscript for loop
VBA
0 vote337 views1 answer
Vbnet check if string is only symbols
VBA