It's possible that the values in the date column of your Excel file are being interpreted as numeric values rather than dates. This can happen if the dates in the column are not formatted as dates in the Excel file, or if the values in the column are entered as numbers rather than as dates.

One way to fix this is to use the pd.to_datetime function from the pandas library to convert the values in the date column to datetime objects. You can then use the dt.strftime method to convert the datetime objects to the desired string format.

Here's an example of how you can do this:

Copy code
import pandas as pd

# Load the Excel file into a pandas DataFrame
df = pd.read_excel('file.xlsx')

# Convert the values in the 'date' column to datetime objects
df['date'] = pd.to_datetime(df['date'])

# Convert the datetime objects to the desired string format
df['date'] = df['date'].dt.strftime('%d/%m/%Y')

# Display the resulting DataFrame
print(df)

This should convert the values in the 'date' column to the desired string format. Let me know if you have any questions or if you need further assistance.