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.
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.
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.
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 |