Ask Your Question

Revision history [back]

Hi, you can open a sheet of Calc, push F4 and open your database in the new window.

Then drag left-top corner in the sheet below and drop it.

In the first cell of new column of the sheet, write: "=IF(LEN(B2)=4;CONCATENATE("0";B2);B2)".

Copy it in the cells below.

Hide the ZIP column.

Rename ZIP the new column.

Select ID and new ZIP column and copy those.

Open your database and paste the select in table area, assign a name and save the new table.

(Excuse me for my bad English and for Italian screenshot)

image description

Hi, you can open a sheet of Calc, push F4 and open your database in the new window.

Then drag left-top corner in the sheet below and drop it.

In the first cell of new column of the sheet, write: "=IF(LEN(B2)=4;CONCATENATE("0";B2);B2)".

Copy it in the cells below.

Hide the ZIP column.

Rename ZIP the new column.

Select ID and new ZIP column and copy those.

Open your database and paste the select in table area, assign a name and save the new table.

(Excuse me for my bad English and for Italian screenshot)

image descriptionimage description