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}