Finnish postal code in Excel

Finnish postal code consists of five number. The first number or first two numbers might be zero. Postal code for Lauttasaari is 00210.

First option is to apostrophe at the start like ‘00210.

In Excel it looks like this.

Second option is to modify format cell.

Select control + 1 or select home – number – arrow lower right hand corner to receive the format cell -window.

In the window select custom category and enter 00000 (five zeroes) to type: box.

Third option is to use TEXT formula.

For the TEXT formula you need to define the cell, where the text is, and format_text 00000 (five zeroes).

Personally, I like the third option as then you can copy the formula downwards, in case you have a list of postal codes.