Formatting numbers as currency
  1. Select the range, row, or column containing the numbers you want to format.

  2. In the action bar, click Range.

  3. In the pop-up menu, click Number Format.

  4. Click the Category box and click "Currency" or "ISO Currency."

  5. Click the Format box and click the country format you want.

  6. To close the pop-up panel, click Pop-up panel close button.



Details



The effect of column width on numbers

If you format a number and the cell fills with *** (asterisks), the column is not wide enough to display the number using the format you selected. To display the number, widen the column to at least one character wider than the width of the formatted number. If your spreadsheet still displays *** (asterisks) after you widen the column, the value is invalid.



Currency

Displays numbers with a currency symbol, thousands separators, and up to 15 decimal places. You can format different cells in the same file as different types of currency. For example, you can format one cell as US dollar and another cell as French franc.



ISO Currency

Displays numbers with the International Standards Organization (ISO) code, thousands separators, and up to 15 decimal places. For example, the ISO code for $ (US dollar sign) is USD.

The table below shows the number 1234.56 displayed as regular and ISO currencies:

A <A HREF="#Currency_symbol_table">table compares the currency symbols for Currency and ISO Currency format for all currencies.



<A NAME="Currency_symbol_table">Currency symbol table

Currency name Regular currency ISO currency
Argentinean Peso A1,234.56 ARS 1,234.56
Australian Dollar A$1,234.56 AUD 1,234.56
Austrian Schilling 1,234.56 ÖS ATS 1,234.56
Belgian Franc 1,234.56 BF BEF 1,234.56
Brazilian Real R$ 1,234.56 BRL 1,234.56
British Pound £1,234.56 GBP 1,234.56
Canadian Dollar C$1,234.56 CAD 1,234.56
Chinese Yuan PRC¥1,234.56 CNY 1,234.56
Czech Koruna 1,234.56 Kc CZK 1,234.56
Danish Krone Dkr 1,234.56 DKK 1,234.56
ECU 1,234.56 ECU XEU 1,234.56
Finnish Markka 1,234.56 mk FIM 1,234.56
French Franc 1,234.56 F FRF 1,234.56
German Mark 1,234.56 DM DEM 1,234.56
Greek Drachma 1,234.56 Dr GRD 1,234.56
Hong Kong Dollar HK$1,234.56 HKD 1,234.56
Hungarian Forint 1,234.56 Ft HUF 1,234.56
Indian Rupee Rs 1,234.56 INR 1,234.56
Indonesian Rupiah Rp 1,234.56 IDR 1,234.56
Irish Punt IR£1,234.56 IEP 1,234.56
Italian Lira L. 1,234.56 ITL 1,234.56
Japanese Yen ¥1,234.56 JPY 1,234.56
Luxembourg Franc 1,234.56 LF LUF 1,234.56
Malaysian Ringgit Rm 1,234.56 MYR 1,234.56
Mexican Peso N$1,234.56 MXN 1,234.56
Netherlands Guilder F 1,234.56 NLG 1,234.56
New Zealand Dollar NZ$1,234.56 NZD 1,234.56
Norwegian Krone Nkr 1,234.56 NOK 1,234.56
Polish Zloty 1,234.56 Zl PLN 1,234.56
Portuguese Escudo 1,234.56 Esc. PTE 1,234.56
Romanian Leu 1,234.56 Lei ROL 1,234.56
Russian Ruble 1,234.56 R SUR 1,234.56
Singapore Dollar S$1,234.56 SGD 1,234.56
Slovakian Koruna 1,234.56 Sk SKK 1,234.56
Slovenian Tolar SIT 1,234.56 SIT 1,234.56
South African Rand R1,234.56 ZAR 1,234.56
South Korean Won W1,234.56 KRW 1,234.56
Spanish Peseta 1,234.56 Pts ESP 1,234.56
Swedish Krona 1,234.56 Skr SEK 1,234.56
Swiss Franc SFr 1,234.56 CHF 1,234.56
Taiwan Dollar NT$1,234.56 TWD 1,234.56
Thai Baht 1,234.56 Bt THB 1,234.56
US Dollar $1,234.56 USD 1,234.56
Other Country OTH 1,234.56 OTH 1,234.56


See also
Why do I need different number formats?
Formatting numbers
Formatting numbers as dates
Formatting numbers as times
Entering a number