Free Tool
Free Locale Currency Format Code Generator (Google Sheets & Excel)
Pick a locale and instantly get the exact currency format code to paste into Google Sheets TEXT(), Excel's custom number format, or any spreadsheet tool. See a live preview of how amounts in your bank statement will render, then copy the ready-to-use format string.
Tool workspace
Run the tool below, then copy or reuse the cleaned output in your spreadsheet or finance workflow.
- The "localeformatcurrency" format string tells Google Sheets and Excel how to render amounts using the currency symbol, grouping, and decimal conventions of a specific country or region.
- Pick your locale below to get the exact TEXT() or custom number format code, plus a live preview.
- These codes are ideal for formatting amounts pulled from a bank statement before export to CSV or Excel.
Live preview
$1,234,567.89
Locale: en-US · Currency: USD
Google Sheets TEXT() formula
=TEXT(A1,"$#,##0.00")
Replace A1 with your amount cell. Google Sheets picks the decimal separator and currency symbol from the spreadsheet's locale (File → Settings → Locale). The currency mark is written as a literal.
Excel custom number format (locale-precise)
[$-409]#,##0.00;[$-409]-#,##0.00
Paste into Excel Format Cells → Custom. The [$-409] prefix forces Excel to render the currency using the Windows locale ID for en-US (409), including the correct symbol, grouping, and decimal placement. Choose “Currency code” above to print an ISO code like USD instead.
Plain number pattern (uses spreadsheet locale)
#,##0.00
Works in both tools when the spreadsheet/regional locale is already set to your target region. The #,##0 grouping and decimal point are localized automatically.
Reference: common Excel currency format codes
| Locale | Currency | Excel custom format |
|---|---|---|
| en-US (LCID 409) | USD | [$USD-409]#,##0.00 |
| en-GB (LCID 809) | GBP | [$£-809]#,##0.00 |
| de-DE (LCID 407) | EUR | [$€-407]#,##0.00 |
| en-IN (LCID 4009) | INR | [$₹-4009]#,##0.00 |
| ja-JP (LCID 411) | JPY | [$¥-411]#,##0 |
| en-SG (LCID 4809) | SGD | [$S$-4809]#,##0.00 |
| pt-BR (LCID 416) | BRL | [$R$-416]#,##0.00 |
| en-AU (LCID C09) | AUD | [$A$-C09]#,##0.00 |
| zh-CN (LCID 804) | CNY | [$¥-804]#,##0.00 |
| sv-SE (LCID 41D) | SEK | [$kr-41D]#,##0.00 |
Input stays in your browser. No upload is required for these free tools.