Zip Codes

Enter a five-digit zip code into a cell and you notice that it's treated like any other number. It's automatically right justified, and if it happens to be a zip code with a leading 0 (e.g. 00256) the zeros are automatically dropped by Lotus.

This macro converts a five-digit zip code into a label (i.e. it's treated like text instead of numbers). It even replaces leading zeroes.

1-2-3 Macro: {EDIT}{HOME}@RIGHT (@STRING({END}+100000,0),5),{CALC} {HOME}'~

System Macro Version:

Comment: 123 Convert ZIPCode

Contents: {EDIT}{HOME}@right(@string ({END}+100000,0),5){F9}{HOME}'{ENTER}