excel vba change format of cell

The solution for “excel vba change format of cell” can be found here. The following code will assist you in solving the problem.

‘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”

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts