Excel format issues when exporting from Reckon

Vince VinceVince
Vince VinceVince Member Posts: 4 Novice Member Novice Member
edited October 2024 in Reckon Accounts (Desktop)

Comments

  • John G
    John G Reckon Staff Posts: 1,569 Reckon Staff
    edited February 2017
    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:
    1. 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.
    2. Go back to the excel sheet and delete the highlighted dates. 
    3. Now highlight the whole date column and right click and select Format Cells. Change the following values to : 
    4.       Locale=English (Australia) 
    5.       Category=Date 
    6.       Type=14/03/2001 
    7. Then go back to the notepad document and copy & paste the dates back into the newly formatted fields 
    Hope this helps.


    regards,
    John



  • Vince VinceVince
    Vince VinceVince Member Posts: 4 Novice Member Novice Member
    edited April 2016
    Much appreciated John.
This discussion has been closed.