Question: how to set date format in excel 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”