Format postcodes as 123-4567

Postcodes typed every which way (1234567, 〒123 4567) made seven digits with a hyphen, all at once.

Drop CSV, Excel, JSON, XML, contacts (VCF) or calendar (ICS) files hereChoose files

For Excel, saving as xlsx keeps the zeros best. For a CSV Excel will open, turn on "Keep zeros" (values become ="0123").

Save as