Question: how to change the date format in excel using macro?
Answer: Selection.NumberFormat = “m/d/yy;@”
expression.NumberFormat.
Selection.NumberFormat.
expression.NumberFormat = “argument_value”
The format code is the same string as the Format Codes option in the Format Cells dialog box.
.NumberFormat = “mmmm” & Chr(10) & “yyyy”