Currency 2 range format

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

Currency 2 range format

This is the macro we played with at the beginning of the article. It sets a range of cells to currency format with 2 digits after the decimal point. The macro will pause and prompt you to select a range of cells to format.

Use the arrow keys to highlight a range, or key one in (e.g. D1..E15). Then press (ENTER).

1-2-3 Macro: '/RFC2~

System Macro Version:

Comment: 123 Currency Format

Contents: {MENU}rfc2{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.