Question: how to specify date format in vba?
Answer: Step #1: Go To The Number Tab Of The Format Cells Dialog Box. Step #2: Select The Date Category. Step #3: Choose The Date Format Type Whose Format Code You Want.