Formatting Issues

How to Display US Dollars and Standard Thousands Separators in Excel

Steve K Oct 1, 2026 869 views

Question details

The user needs to format numerical values as US dollars using standard three-digit thousands separators.

How to Display US Dollars and Standard Thousands Separators in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Formatting large financial data when the default system region applies alternate number groupings, such as Indian lakhs and crores.
Observed behavior: Numbers are grouped incorrectly based on regional settings (e.g., 10,00,000) instead of the standard western format (1,000,000).

Before you start

Verify whether your financial data requires decimal places for cents, as you will need to adjust the custom formatting code accordingly.

Solution 1Recommended

Apply a Custom US Currency Format

Use a specific custom format code with a US locale tag to override your system's regional settings and force standard thousands separators.

If your computer's regional settings default to different numbering systems, standard currency formats might still use those regional groupings. By using a locale-specific custom code, you guarantee that Excel applies the standard three-digit grouping.

Select the target cells

Highlight all the cells containing the numbers you want to format.

Open Format Cells

Right-click the selected cells and choose 'Format Cells' from the context menu, or press the 'Ctrl + 1' keyboard shortcut.

Navigate to Custom formats

In the Format Cells dialog box, go to the 'Number' tab and select 'Custom' from the Category list on the left.

Enter the format code

In the 'Type' input box, enter [$-en-US]$#,##0 or $#,##0_);($#,##0) to display the dollar sign and standard separators without decimals. Click 'OK' to apply.

Format successfully applied: Your numbers will now display as standard US currency (e.g., $1,000,000) regardless of the system's regional configuration.

Solution 2

Use Built-in Currency or Number Settings

Use Excel's standard Currency or Number format options if your system's default region already supports standard thousands separators.

Easily Format Currency and Numbers in WPS Office

WPS Spreadsheet provides a highly compatible and intuitive interface to quickly apply custom formats, US currency symbols, and standard thousands separators to your financial data.

1. Open your spreadsheet: Launch WPS Spreadsheet and open the document containing your financial data.
2. Access cell formatting: Select the cells you want to modify, right-click, and choose 'Format Cells'.
3. Apply custom formatting: Navigate to the 'Number' tab, select 'Custom', and input [$-en-US]$#,##0 to instantly update your number grouping to US standards.

Fully compatible with Microsoft Excel format (.xlsx)Intuitive Format Cells dialog for quick custom number formattingLightweight, fast, and completely free to use

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel display numbers as 10,00,000 instead of 1,000,000?

This happens when your computer's regional settings are configured for a region that uses a different numbering system, such as the Indian system of lakhs and crores. Excel inherits these settings by default.

How do I add decimal places to the custom dollar format?

To include two decimal places for cents, modify the custom format code in the Format Cells dialog to [$-en-US]$#,##0.00.

Can I permanently change the default number format on my computer?

Yes, you can change your operating system's Regional Settings (via the Control Panel in Windows or System Settings in macOS) to a region that uses standard thousands separators, such as the United States or the United Kingdom. This will update the default grouping across Excel and other applications.

Document & File Issues