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}