Zip Codes

Everything HP200LX: Knowledge, Products, Service

Archives
9 years, 100's of pages of HP Palmtop Paper, jammed with tips, reviews and how-to's

Links
Most useful, up-to-date Web sites devoted to the HP 200LX

Downloads
Direct link into 1000's of pieces of Palmtop software

Tips from Our Techs

2008 Catalog
(PDF, 2.6 MB)

Contact Us/About Us

Privacy Policy

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}

Notice about Palmtop.net
The Palmtop Network with its S.U.P.E.R. (Simply Unbeatable Palmtop Essentials Repository) software is now available under the domain name of hp200lx.net.