vba set cell format to date code example
Example: excel vba set cell format to date
'In Excel, dates are actually just numbers that have a special
'formatting applied to display like dates.
'VBA code to change the Number Formatting of a cell range:
[A1].NumberFormat = "mm-dd-yyyy"
'There are hundreds of options for Number Formats. The above sets
'cell A1 to display numbers as a date in the American style.
Here are a few other Number Formats:
[A1].NumberFormat = "General"
[A1].NumberFormat = "$#,##0.00"
[A1].NumberFormat = "@" '<-- Text