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
This discussion has been closed.