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 vote156 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote167 views1 answer
Weekday vba
VBA
0 vote178 views2 answers
Checking and changing system volume vb.net
VBA
0 vote150 views1 answer
Excel vba show developer tab
VBA
0 vote207 views1 answer
Excel vba protect content
VBA
5 votes183 views1 answer
Excel vba how to unit test vba code
VBA
0 vote161 views1 answer
WGET FTP
VBA
0 vote192 views1 answer
Amd64 vs arm64 linux
VBA
0 vote161 views1 answer
Excel vba protect sheet
VBA
-1 vote182 views1 answer
Code for reading letters only in vb 6
VBA