TJ-4020TN
 |
FAQs & Troubleshooting |
Why is the leading zero (0) missing after importing the database into P-touch Editor?
For TD-4T/TJ-4T series:
To use P-touch Editor, download and install “Printer Driver for P-touch Editor” from the [Downloads] section of this website.
The column format must be set as Text format so that the leading zeros appear in P-touch Editor after you imported them. Please do the following steps to correct this issue.
For Microsoft Excel:
- Open your Microsoft Excel file.
- Right-click on the column field that has the missing zero(s) and select [Format Cells].
- In the Format Cells dialog box, click the [Number tab].
- In the Number tab under [Category], select [Text], and then click [OK].
- From the menu bar, click [File] and select [Save] to save the file.
- Click [File] again and select [Exit] to close the program.
For Microsoft Access:
- Open your Microsoft Access file.
- In the dialog box, click [Tables] under [Objects].
- Right-click the table name of the database and select [Design View].
- Under [Field Name] (the first column) in the [Design View] window, locate the field that has the missing zero(s).
- Click the Date Type cell for that field. The pull-down arrow will appear in the cell.
- Click the pull-down arrow and select [Text].
- From the menu bar, click [File] - [Save] to save the file.
- Click [File] again and select [Exit] to close the program.
Related Models
PJ-623, PJ-663, QL-1100/1100c, QL-1110NWB/1110NWBc, QL-710W, QL-720NW, QL-800, QL-810W/810Wc, QL-820NWB/820NWBc, RJ-3050, RJ-3150, RJ-3230B, RJ-3250WB, RJ-4030, RJ-4040, RJ-4230B, RJ-4250WB, TD-4210D, TD-4410D, TD-4420DN/4420DN(FC), TD-4420TN, TD-4520DN, TD-4520TN, TD-4550DNWB / 4550DNWB(FC), TD-4650TNWB, TD-4650TNWBR, TD-4750TNWB, TD-4750TNWBR, TJ-4020TN, TJ-4021TN, TJ-4021TNR, TJ-4120TN, TJ-4121TN, TJ-4121TNR, TJ-4420TN, TJ-4422TN, TJ-4520TN, TJ-4522TN, TP-M5000N
