Currency

The Currency format is used to display numbers with a currency sign or code, which corresponds to the system settings of your computer.

A number formatted as Currency

To quickly convert a cell into the Currency format once the data is entered, perform the following actions:

1.Select a cell or a range the format of which you want to change.

2.On the Home tab, in the Number format group, click  Currency.

A cell is automatically formatted as Currency if you specify the currency code next to the number. For example, 23.00 USD or USD 23.00. For the full list of supported currencies and their codes, see Appendix B.

The following parameters can be set for the number in the Currency format:

•Currency code and symbol to be entered next to the number

•The number of characters displayed after the dot (.) delimiter

•Negative number presentation type