Excel format issues when exporting from Reckon
Vince VinceVince
Member Posts: 4 Novice Member
I am using Reckon Accounts Premier Manufacturing and Wholesaling Edition
When I export reports from Reckon to Excel the format (eg dates) looks ok but it isn't actually an Excel recognised date format which means I can't sort unless I manually go into each cell and hit ENTER. That is fine for 50 lines but not so for 2000.
I also have issues with formulas and the like but the dates one is causing me the most grief.
Is there a setting within Reckon that I can choose that will make it export properly?
When I export reports from Reckon to Excel the format (eg dates) looks ok but it isn't actually an Excel recognised date format which means I can't sort unless I manually go into each cell and hit ENTER. That is fine for 50 lines but not so for 2000.
I also have issues with formulas and the like but the dates one is causing me the most grief.
Is there a setting within Reckon that I can choose that will make it export properly?
0
Comments
-
Hi Vince,
Welcome to the Reckon community.
Many programmes experience this issue with exported dates to Excel.
One simple workaround is to export the Report to a CSV file, then open that CSV file in Excel.
If that does not work another workaround is:- Export your report to Excel as per normal Highlight all the dates in the date column and copy & paste these to a new notepad document.
- Go back to the excel sheet and delete the highlighted dates.
- Now highlight the whole date column and right click and select Format Cells. Change the following values to :
- Locale=English (Australia)
- Category=Date
- Type=14/03/2001
- Then go back to the notepad document and copy & paste the dates back into the newly formatted fields
regards,
John
0 -
Much appreciated John.
0
Categories
- All Categories
- 6.6K Accounts Hosted
- 15 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 7 📢 Reckon Accounts Desktop - Announcements
- 1.4K Reckon Payroll 🚀
- 32 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 24 Reckon Mate App
- 2.6K Reckon One
- 8 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 15 Reckon Insights
- 99 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 66 About Reckon Community