Quotation marks are being added to the account, description, or account balance fields when using Paste TB import in CCH® ProSystem fx® Engagement and Workpaper Manager.
- Article Type:
- Problem Resolution
- Last Modified:
- 02/13/2020
Symptoms
When performing a Paste TB Import in Microsoft® Excel® quotation marks are inserted either or all columns for the account number, account description, or balance columns causing them to be invalid accounts which prevents them from properly importing.
Environment
- CCH ProSystem fx Engagement
- CCH ProSystem fx Workpaper Manager
- Microsoft Excel
Cause
While not visible in the workbook there's hidden formatting or invisible quotation marks in the cells in Microsoft® Excel®. This is normally when the data was imported or converted from another software programs.
For known examples:
For known examples:
- Importing from Quickbooks.
- Converting a PDF to Microsoft® Excel®
Resolution
- Run the Text to Column function. (Note: Microsoft® Excel® can only change one column at a time.)
- Open Microsoft® Excel®,
- Select the column or cells that are affected.
- Click on the Data ribbon.
- Click Text to Column function.
- Leave the defaults and click Finish.
- Save and close the workbook.
- Reopen the workbook.
- Copy the data and use paste TB import.
- If the above is still occurring with the balance columns only, try changing the formatting to Currency.
- Open Microsoft® Excel®
- Select the balance column(s).
- Right-click and select Format Cells.
- Click Currency.
- Click OK.
- Re-attempt to Copy the data and use paste TB import.
- Workaround the issue by manually removing the quotation marks with Notepad.
- In Microsoft® Excel® Click File
- Click Save As and cick Browse.
- Save the file the Desktop.
- Change the format from Excel Workbook to Text (Tab delimited).txt.
- Close Microsoft® Excel®.
- Open the (.txt) file in Notepad.
- In Notepad click Edit menu.
- Select Replace...
- In "Find what" type in: "
- Leave "Replace with" blank (no spaces)
- Click Replace All.
- Save over the file in Notepad.
- Open Excel and go to File >Browse.
- Open the .txt file in Microsoft® Excel®.
- Use the defaults settings when prompted to open the file.
- Recopy the content and Paste TB Import into Engagement.
- For instructions on how to paste TB import, see our solution how do I import numbers into my CCH® ProSystem fx® Engagement or Workpaper Manager Trial Balance from a Microsoft® Excel® document?
Additional Information
N/A
Solution Id | 000094483/000094483 |
---|---|
Direct Link |