Aug 05 2020 06:59 PM
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-0105, 4-5100 & 1-1410. When I view the data in the text file these values are correct. After the file is imported the error log shows that the values have been changed to 1488, 1314 & 1585.
I've attempted the following solutions:
- changing format of the whole sheet from General, to Number and to Text (some of the test sheets have preserved the format of 5-0105 and 1-1410 account numbers but the 4-5100 is always changed)
- using text import wizard to bring in text data to new Excel sheet, selecting delimiters, changing the account column formatting to both Text and General
- rewriting data in individual cells and then tabbing out (rather than enter)
- saving as .csv file - all of the same issues
- MYOB support tried similar solutions without success.
NO JOY. HOURS LOST.
Hoping someone can assist!
Aug 06 2020 12:56 AM
can you share a sample file
Aug 06 2020 06:59 PM
Have just added - thanks @Ramiz_Assaf
Aug 06 2020 07:00 PM
Aug 06 2020 10:10 PM
Aug 07 2020 12:11 AM
Thanks @Ramiz_Assaf
I've uploaded a list as exported out of MYOB into Text Document and the contents copied and pasted into the excel spreadsheet. Hope you can see something I can't!!
Aug 07 2020 12:48 AM
Aug 07 2020 06:03 AM