Single quote issue in COA using DTW
I am using DTW to import Chat of accounts in to the test Database.
i just fill 2 rows, 1 for title account and 2nd for active account.
the "fatheraccountkey" is automatically converted in to exponential form even i had put single quote. pls help
The note has no solution info regarding your issue. What you can do is:
1. Enter a single quote first following the number. It should be displayed as text and left aligned. If not, you need to edit the cell to add a single quote in front of the number.
2. Save the file as TXT (Tab Delimited) type. This format is the best for DTW use.
3. Before DTW, always open the text file by notebook to check. You can correct any format within notebook in case nothing works by handling within excel.