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 vote151 views1 answer
Vb streamreader
VBA
0 vote244 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote163 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote165 views1 answer
Vba remove last vbcrlf
VBA
3 votes147 views1 answer
Excel vba make long from two shorts
VBA
0 vote153 views1 answer
Vbscript for loop
VBA
27 votes291 views2 answers
Vba check if file exists
VBA
0 vote178 views1 answer
Iterate all file in a folder vba
VBA
0 vote182 views1 answer
Create new worksheet excel visual basic
VBA
3 votes169 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA