Refer below steps to resolve date formatting issue while processing data.
Step 1:- First of all select the Columns containing the “dates”
Step 2: Select Text To Columns. You’ll find this on the DATA tab/menu, depending on which version of Excel you are using.
Step 3: Ensure that the original data type is set to Delimited and click Next
Step 4: Ensure that all the check boxes are clear and click Next
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.
You might be interested in our other Products / Services
Most Preferred Data Import Utility for Online Sellers
Import any Online Portal Order-wise Sales, Returns & Settlement Data to Tally!
Most Preferred Job Portal for Accountants
Fastest Growing Job Portal for Accounting Community!
Payroll & Attendance Simplified for SME & Startups
Leave A Comment