I'm using Excel 2016, and just upgraded to Sage 50 Pro Accounting 2016 because the Sage sales guy said that it was compatible with Excel 2016. However, when doing "Open in Excel", it only shows the option of Excel 97 - 2007. After saving this .xls file and opening it in Excel 2016, none of the numeric data is in numeric format - it is in text format. Also, the non-numeric data has a single quote mark at the start of every field. If I try to click the "comma" number format, it says "Style "comma" not found".
I tried exporting to CSV instead, and this works a little better (no single quote marks at the start of every non-numeric data field), but all the zeroes are not numeric, and thus when copying this into another Excel worksheet, it causes #VALUE errors.
Is there a way to export to an Excel file so that all the numeric data is formatted as numeric data?
If anyone has an answer, I'll be very happy!!