Hi Jonathan,

Sure, I can help you with that. Here's a code snippet that you can use to convert the date/time format to date only format:

1. Open your Excel workbook and press Alt + F11 to open the
   Formula:

   VBA 

   editor.
2. Insert a new module by clicking on "Insert" "Module".
3. Copy and paste the code below into the module.
   
   
   Formula:

   Sub ConvertDateTimeToDate()
    Dim cell As Range
    For Each cell In Selection
        If IsDate(cell.Value) Then
            cell.Value = Format(cell.Value, "dd/mm/yyyy")
        End If
    Next cell
End Sub 

4. Close the
   Formula:

   VBA 

   editor and go back to your worksheet.
5. Select the range of cells that contain the date/time values you want to convert.
6. Press Alt + F8 to open the Macro dialog box.
7. Select the "ConvertDateTimeToDate" macro and click "Run".

This code loops through each cell in the selected range and checks if the cell contains a valid date. If it does, it formats the date to the "dd/mm/yyyy" format and replaces the original value in the cell.