Date Picker issue

[Jeffc41]

Hi All,
I have added date picker to multiple columns in excel for a tracking database. I do not want the time stamp included.
I have tried setting the format of the date in format cells and all the suggestions on google. It works at first and when I save, shut down and restart the time stamp returns to cells. Please can anyone help me stop the timestamp in all date picker cells?
This is all I need to complete my database and I am completely stuck.
Thanks in advance for suggestions. I am new to this so any screen shots would help.
Thanks all.
Jeff

 

[mrshl9898]

If formatting isn't working, try this (replacing A1 with the cell with the date):

=TEXT(A1,"dd/mm/yyyy")