I have a sizable excel file with the date listed in one column. The issue is that the date in this column is shown in various ways, as follows:
Some of them include a time stamp, while others use the format dd/mm/yy or mm/dd/yy. I require a single mm/dd/yy form (no time stamp). I have tried the fundamental techniques, such as formatting the cell by selecting the category and selecting a single date format, but the values of m/d/yy h:mm;@ remain unchanged. I also tried using datevalue with the following formula to retrieve the value in a new column: DAY(D2) & "/" & YEAR(D2) & "/" & MONTH(D2) & "/" Once more, it is ineffective. Any solutions to resolve this would be greatly appreciated.