Originally Posted by
Questor
Hi Justloadit - my Windows (10) settings are as you specified but it makes no difference.
I noticed something weird though - the numbers are not all in the same format. Some are left-justified with no separator and a comma for decimal and others are right-justified with a comma as the separator and a period for the decimal point. This for both debit and credit columns.
Moreover, the apostrophe only appears in blank cells in the debit column.
The data is exported from a very old Pastel Xpress, I believe, which might be compounding the problem. I did have a workaround for this problem as suggested by acheronia below but that doesn't work in this case.
Next step: I'll contact a Pastel/Sage reseller in Cape Town and see if he can shed some light.
Thanks for your help, though.
Did you like this article? Share it with your favourite social network.