Removing Duplicates with Timestamp

[Andy0311]

Hello,
I have a column of datestamps in a sheet and I need to separate the date from the time (=Int or =left both work). Then I copy the formula down. With the column highlighted, I go to Data and use the Remove Duplicates function. The result lists the distinct dates, but when I click OK, the dialog box closes and what remains is only the first date times the number of distinct days. For example, here is a column where I want to remove the duplicates. When I do that, in the column to the right, I do not get 9/17/2019, 9/18/2019, and 9/19/2019, but instead 9/17/2019 listed three times.

[TABLE="class: outer_border, width: 700, align: center"]
<tbody>[TR]
[TD]9/17/2019[/TD]
[TD]9/17/2019
[/TD]
[/TR]
[TR]
[TD]9/17/2019[/TD]
[TD]9/17/2019[/TD]
[/TR]
[TR]
[TD]9/18/2019[/TD]
[TD]9/17/2019[/TD]
[/TR]
[TR]
[TD]9/19/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9/17/2019[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


If I do the same operation with :
1
2
1
3


I get:
1
2
3

Does anyone know why that is happening? Thank you for your help.

 

[Andy0311]

Curious, which suggestion ended up working for you?

Text to Columns worked best for me, because it's the easiest for me. All suggestions were very helpful, and pointed to the formatting problem. Thanks to everyone! A

 

[Joe4]

Glad we were able to help.