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”