Format Currency

Use this tool to apply format of currency to a range of cells.

Change the format of your numbers using the Format Currency tool . Click many times to see other types of number formats.

1 click without decimals

2 clicks with one decimal

3 clicks with 2 decimals

Settings

In order to gain access to this tool, go to panel Quick styles and press the button

And a dialogue settings box will be displayed in which you should select the section of iterative tools, the button

Note:

This Function is available for Excel 2007 only