Refer below steps to resolve date formatting issue while processing data.

Step 1:- First of all select the Columns containing the “dates”

 

Date format issue in Excel

 

Step 2: Select Text To Columns. You’ll find this on the DATA tab/menu, depending on which version of Excel you are using.

 

Date format issue in Excel

 

Step 3: Ensure that the original data type is set to Delimited and click Next

 

Date format issue in Excel

 

Step 4: Ensure that all the check boxes are clear and click Next

 

Date format issue in Excel

 

Step 5: Set the Column Data Format to DMY and Click Finish button this format is DD/MM/YYYY is format is correct date format.

 

Date format issue in Excel

You might be interested in our other Products / Services

Most Preferred Data Import Utility for Online Sellers

eCom2Tally.in

Import any Online Portal Order-wise Sales, Returns & Settlement Data to Tally!

Most Preferred Job Portal for Accountants

Jobs4Tally.com

Fastest Growing Job Portal for Accounting Community!

Payroll & Attendance Simplified for SME & Startups

HR4Tally.in