Forum Discussion
Earl_HD
9 months agoMYOB Moderator
Hi donna-r,
Thanks for providing the screenshots. This error occurs because Microsoft Excel adds double quotation marks to values when you save as a text file (Tab Delimited) or CSV, especially when a value contains a comma.
Before importing again, remove the quotation marks or change the column format in Excel so the values are saved without them; then re‑save and import the file. There are several ways to do this, the simplest is to adjust the column format in Excel and re‑save.
Please see image attached:
Before.
After.
I hope this helps!
Regards,
Earl
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Learn, solve, grow
Level up your skills and find answers across all MYOB products