It shouldn't matter, you would get the datevalue instead which should be unqiue/allow you to remove duplicates.
You could type:
=A2 & " " & Text(D2,"DD/MM/YYYY")
if you really want it to display the dates.
It shouldn't matter, you would get the datevalue instead which should be unqiue/allow you to remove duplicates.
You could type:
=A2 & " " & Text(D2,"DD/MM/YYYY")
if you really want it to display the dates.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks