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 vote36 views1 answer
Excel delete ever other vba
VBA
0 vote34 views1 answer
Vba text to general
VBA
0 vote34 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote36 views1 answer
Default host vbox address
VBA
5 votes35 views2 answers
Excel vba write to the windows registry
VBA
0 vote6 views1 answer
Quit excel with save changes dialog vb.net
VBA
3 votes33 views1 answer
Vba request json
VBA
0 vote36 views1 answer
Excel vba unmerge sheet
VBA
0 vote31 views1 answer
Enter into cells data grid view
VBA
5 votes38 views1 answer
Excel-vba get integer high byte
VBA