Is there a way to remove the "S" from the check number field on reports
Found at:
But there is a way to get a Quicken listing, or .TXT file, of check transactions for a single account that do not display an "S" in the check# field of any split transactions. [But, the report or file may not handle other fields as desired (date, for example, may not display fully) - check# and amount appear to be displayed correctly.]
Here are the steps:
- Sort the account register by Check # (click on the "Check #" heading text)
- Select only the actual check transactions (as you would select files in Windows Explorer)
- Right-click a selected transaction
- Select "Edit transaction(s)"
- In the resulting "Find and Replace" dialog, click the small printer icon in the lower left
- Select "Text file" in the "Export to" dropdown
- Click the "Export" button
If some fields are not accurate enough in the resulting .TXT file, I believe Excel (or similar) is the only option.
But using the above technique, you can also create a tab-delimited file of the transactions in the "Find and Replace" dialog. If you create a tab-delimited file from the Quicken "Find and Replace" dialog, all the fields will exported accurately, and once the tab-delimited file is opened in Excel, there will be no need to remove the "S" from the check# field for split transactions, as that "S" will not be exported. You can easily remove any unwanted fields (columns) from the Excel file before saving the Excel data to a .TXT file.