Excel format issues when exporting from Reckon
Vince VinceVince
Member Posts: 4 Novice Member
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.