FAQs & Troubleshooting

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:

1. Open your Microsoft Excel file.
2. Right-click on the column field that has the missing zero(s) and select [Format Cells].
3. In the Format Cells dialog box, click the [Number tab].
4. In the Number tab under [Category], select [Text], and then click [OK].
5. From the menu bar, click [File] and select [Save] to save the file.
6. Click [File] again and select [Exit] to close the program.

For Microsoft Access:

1. Open your Microsoft Access file.
2. In the dialog box, click [Tables] under [Objects].
3. Right-click the table name of the database and select [Design View].
4. Under [Field Name] (the first column) in the [Design View] window, locate the field that has the missing zero(s).
5. Click the Date Type cell for that field. The pull-down arrow will appear in the cell.
6. Click the pull-down arrow and select [Text].
7. From the menu bar, click [File] - [Save] to save the file.
8. Click [File] again and select [Exit] to close the program.