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"

Updated on: 21/12/2021

Was this article helpful?

Thank you!