Question: how to set default date format in vba?
Answer: The NumberFormat property can be used in VBA to set the number format of dates in a cell or range. Note: In order to see the different standard date formats available in Excel go to Home>Number and you'll see options such as Short Date, Long Date and Time.