Why is the leading zero (0) missing after importing the database into P-touch Editor?

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.

If your question was not answered, have you checked other FAQs?

Have you checked manuals?

If you need further assistance, please contact Brother customer service:

Related Models

PJ-623, PJ-663, QL-1100, QL-1110NWB, QL-720NW, QL-800, QL-810W, QL-820NWB, RJ-3050, RJ-3150, RJ-4030, RJ-4040, RJ-4230B, RJ-4250WB, TD-4420DN, TD-4550DNWB

Content Feedback

To help us improve our support, please provide your feedback below.

Step 1: How does the information on this page help you?

Step 2: €Are there any comments you would like to add?

Please note this form is used for feedback only.