delete time from datetime format

[smithrd6]

How to delete the time from the date/time content. Currently shows 5/5/2011 02:12:45, want to see only 5/5/2011

 

[MrKowz]

If you want to just show the date, but keep the time stored as a part of the value, format the cell as a date.

If you want to change the actual cell value so it is only a date, try:

=INT(A1)

and format that cell as date.

 

[smithrd6]

works with one challenge, when copying formula down the remaining rows, date does not change to match source cell

 

[MrKowz]

I don't understand. Can you please provide an example of how your data is set up and what your desired result is?