How to format a date pulled from a cell?

Hi,

cell A1 of my sheet1 contains a date and i am using this cell value to insert some text in cell D2 of sheet2.

I am using following line in vba code

Please Login or Register  to view this content.

what change should i make in the code to get the date format in DD/MM/YYYY in cell D2 of sheet2, irrespective of the date format in sheet1?

Thank you!

format("01/01/1900","dd/mm/yyyy")

Thank you!