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.