Forum Discussion
bree_anastasi
Aug 06, 2020Copper Contributor
Excel to .txt file - number formatting issues
Hoping someone can help here - I'm at my wits end. I have data from an excel file that I have saved as a .txt file that I'm importing into MYOB. This data includes references to account codes - 5-0...
NikolinoDE
Aug 07, 2020Gold Contributor
Since you have already tried many things, I can only point out something simple.
Was the Excel file unsaved before you made it a txt file?
Especially when importing SAP Excel files this error occurs (sometimes ... not always), so it would be good if you save the Excel file in your PC beforehand and then convert it ... according to the idea, it should not then happen ... is just a little hint.
Nikolino
I know I don't know anything (Socrates)
Was the Excel file unsaved before you made it a txt file?
Especially when importing SAP Excel files this error occurs (sometimes ... not always), so it would be good if you save the Excel file in your PC beforehand and then convert it ... according to the idea, it should not then happen ... is just a little hint.
Nikolino
I know I don't know anything (Socrates)