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 votes290 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote322 views1 answer
Style percent not found vba
VBA
2 votes281 views1 answer
Vba uppercase first letter of each word
VBA
5 votes374 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote298 views1 answer
Freeze panes vba
VBA
0 vote306 views1 answer
Vba excel do not recalculate before save
VBA
0 vote292 views1 answer
Sendkeys vba selenium
VBA
11 votes425 views1 answer
Excel vba How to URL encode a string
VBA
-1 vote305 views1 answer
Vba code to add new column in table
VBA
2 votes284 views1 answer
Vba array contains
VBA