How to format "Date" in XLSX using Microsoft Excel

Step 1:

Highlight the date column, right click on highlight and select "Format Cells"



Step 2:

Select "Date" and format it to "DD/MM/YYYY"

Was this article helpful?
Cancel
Thank you!