Vba format cell as date

Vba format cell as date Vba excel format cell as date. Vba format cell as uk date. Vba format cell as datetime. Vba format cell as custom date. As per following image, After running the code some of the date cells do not format as defined. How do I change the code to get "dd-mmm-yyyy" formats Anbuselvam K Eg those A12: A14-cells values are not ... ................
................