In Excel, US number format generally means using a period for the decimal mark, a comma for thousands, month/day/year dates, and US currency symbols such as $. To apply a format, select the cells, press Ctrl+1 on Windows, choose a category such as Number, Currency, or Date, set the desired options, and select OK; formatting changes how values appear, not the values stored in the cells.
What US number format means
There is no single Excel setting called “US number format” that changes every part of a workbook in one action. The phrase usually refers to a group of conventions commonly used in the United States. For example, 1,234.56 uses a comma to group thousands and a period before the decimal digits. A US-style date such as 7/4/2026 means July 4, 2026, and a US currency display might show $1,234.56.
Number formats are applied to cells or ranges. A workbook can therefore contain US-style currency in one column, dates in another style, and general numbers elsewhere. A format may also be selected for a particular purpose: a financial report might show two decimal places, while a headcount table should show whole numbers.
- Number: displays numeric values with chosen decimal places and optional thousands separators.
- Currency or Accounting: displays a currency symbol and controls decimal places; Accounting also aligns symbols and decimal points in a column.
- Date and Time: displays date or time values using a chosen pattern, such as month/day/year.
- Percentage: displays a value as a percentage, so 0.15 appears as 15%.
How Excel stores numbers and dates
Excel stores numbers as numeric values and applies a display format on top. If a cell contains the number 1234.5, a format with two decimal places and a thousands separator can display it as 1,234.50. Changing that cell to show no decimal places may make it appear as 1,235, but the stored value remains 1234.5. Calculations continue to use the stored value unless a formula or other operation changes it.
Dates are also stored as numbers in Excel’s date system. A date format tells Excel to display a date value as a calendar date rather than as an ordinary number. This distinction explains a common surprise: applying a date format to text that merely looks like a date will not necessarily turn that text into a real date. Formatting affects display; converting text to a date is a separate task.
Percentage formatting is another useful example. If a cell contains 0.15, applying Percentage displays 15%. It does not simply add a percent sign to the digits; it displays the underlying value multiplied by 100. If you enter 15 and then apply Percentage, the result is 1,500%, because the stored number is 15.
Apply a US-style format in Excel for Windows
For Excel for Microsoft 365 on Windows, the Format Cells dialog gives the most control. Select the cells, press Ctrl+1, and use the Number tab. Choose a category, adjust its settings, and select OK. For dates, select Date and choose a suitable type; for amounts, choose Currency or Accounting and select the symbol and number of decimal places.
The Home tab offers quicker options. Select a range and use the Number Format list in the Number group to choose Number, Currency, Short Date, or another available format. The comma-style thousands separator and decimal-place buttons in that group can also adjust the appearance of selected numeric cells. The exact choices in the list can vary with Excel’s regional settings.
- Select the target cells or column. Selecting the whole column first can help keep future entries consistent.
- Open the Number Format list on the Home tab, or press Ctrl+1 for more options.
- Choose the category and settings that match the data, such as two decimal places for prices or a date pattern that makes the month clear.
- Check several cells, including large values, negatives, blanks, and dates, to confirm the result is readable.
On a Mac, select the cells and use Command+1 to open Format Cells; the menu labels are similar, though some controls and locations differ from Windows. In Excel for the web, use the Home tab’s number-format controls. The desktop dialog provides a broader set of formatting options, so a custom format or detailed locale choice may be easier to set in desktop Excel.
Useful US formats and examples
In a US installation, common display patterns include #,##0.00 for two decimal places with thousands grouping, $#,##0.00 for a dollar amount, and m/d/yyyy for a date such as 7/4/2026. In the Format Cells dialog, choose Custom to enter a custom pattern. The standard Number, Currency, and Date categories are often easier for routine work because their controls explain the available choices.
Custom number formats can show positive values, negative values, zero, and text differently. For example, a format may display negative amounts in parentheses or show a dash for zero. Custom formats change the appearance, not the value, and should be chosen carefully so a reader can still understand what the cell means. A displayed dash, for example, might represent zero rather than missing data.
For dates, m/d/yyyy uses a numeric month, while mm/dd/yyyy adds a leading zero to single-digit months and days. A format such as mmm d, yyyy displays a month abbreviation, making dates less ambiguous to readers who might confuse month and day positions. In date format codes, capitalization can matter for distinguishing months from minutes in some patterns, so select a built-in date type if you are unsure.
Choose a format based on the reader and the task, not just the appearance of a sample cell. A report of invoice totals may benefit from a dollar sign, while a table containing counts should not look like currency. For rates, decide whether the source values are decimals such as 0.15 or whole-number percentages such as 15 before applying a percentage format.
Regional settings and separators
Excel’s default separators and date interpretations can depend on the operating system’s regional settings and Excel’s own options. On Windows, Excel for Microsoft 365 has a Use system separators setting under File > Options > Advanced, in the Editing options area. When that setting is enabled, Excel follows the system’s decimal and thousands separators. If it is cleared, you can specify separators for Excel instead.
Changing separators affects how numbers are displayed and how Excel interprets some typed or imported data. It is not a casual cosmetic adjustment for a workbook shared across countries: another person may see different separators under their own settings. On Mac, Excel’s separator controls are available in Excel settings or preferences under Advanced, though the wording and location can vary by version. Excel for the web may use regional preferences associated with the account or organization, and some controls differ from desktop Excel.
Regional settings also matter when entering dates. In a US date convention, 03/04/2026 normally means March 4, 2026. In a day/month/year convention, the same characters can mean 3 April 2026. If a workbook is shared internationally, use an unambiguous display such as a month name or a four-digit year, and check that the underlying cells are actual dates.
Importing data without misreading it
Imported files can bring in numbers and dates as text, especially when the source uses different separators or regional conventions. A value such as 1.234,56 may represent one thousand two hundred thirty-four and 56 hundredths in a comma-decimal locale, but it can be read differently by a US-configured process. Applying a US number format afterward does not reliably repair a value that Excel imported as text or parsed incorrectly.
For a CSV file in Excel for Windows, use Data > From Text/CSV to inspect the preview before loading it. If you need to control how a column is interpreted, choose Transform Data to open Power Query. In Power Query, select the column, then use its data type control and choose Change Type > Using Locale. Select the appropriate data type and locale for the source, such as English (United States) when the source really follows US conventions. Confirm the preview before loading the results.
For a small amount of text data, Data > Text to Columns can help convert values; its date option lets you specify a date order such as MDY. Always check a few converted results against the original source. A date column with ambiguous values cannot be interpreted safely by appearance alone; consult the source documentation or ask the data provider which convention was used.
Common problems and how to fix them
- Formatting has no visible effect: the cells may contain text rather than numbers or dates. Check whether values are left-aligned unexpectedly or have a leading apostrophe, and convert the data before applying a number format.
- Dates show as serial numbers: the cells may be formatted as General or Number. Apply a date format if the stored values are valid Excel dates.
- A date changes to the wrong month and day: Excel may have interpreted the entry using a different regional order. Verify the actual date value and re-import or convert it using the source’s known locale.
- Numbers show unexpected commas or periods: check Excel’s system-separator setting and regional settings, as well as the source file’s conventions.
- Values display as ####: the column may be too narrow for the selected format. Widen the column or use a shorter display pattern; this usually does not mean the value is lost.
Another frequent issue is confusing a rounded display with a rounded value. A cell shown with zero decimal places can still contain many decimal places, which affect calculations. If the business requirement is to change the value itself, that requires an explicit calculation or rounding operation; changing the number format alone only changes what is shown. Keep that difference in mind when totals appear not to match the sum of the rounded figures on screen.
Choosing formats for shared workbooks
When a workbook will be read by people using different regional settings, prioritize clarity. Month names reduce ambiguity in dates, and clearly labeled currency columns help readers distinguish dollars from other currencies. Avoid relying only on a symbol if the workbook includes amounts from multiple countries; label the currency in a heading or nearby note.
For repeatable reports, apply formats to entire data columns or use an Excel table so new rows can inherit consistent formatting. Test the workbook on a copy if separator or locale changes are needed, and check both displayed values and calculations. If a workbook feeds another system, preserve the raw imported data when possible and perform conversion in a clearly identified column or query step. That makes it easier to trace how a value was interpreted.
Frequently Asked Questions
How do I change Excel to US number format?
Select the cells, press Ctrl+1 on Windows, and choose a US-style Number, Currency, or Date format. To change separators used by Excel, check File > Options > Advanced > Use system separators.
What is the US format for dates in Excel?
A common US date display is month/day/year, such as 7/4/2026 for July 4, 2026. Use a month-name format when readers might mistake the month and day positions.
Does changing number format change the value?
No. A number format normally changes only the cell’s display. The underlying value remains available to calculations, even if fewer decimal places are shown.
Why does Excel show a date as a number?
Excel stores dates as serial numbers. If a valid date cell is displayed as a number, select it and apply a Date format. If the entry is text, convert it to a real date first.
Why does a US number format use the wrong decimal separator?
Excel may be following system separators or regional settings, or the source data may use a different convention. Check Excel’s separator options and verify how imported values were parsed before changing their display.
Related
- Sales Order Tracking Excel Template: Setup and Tips
- RSVP List Template Excel: Build and Track Guest Replies
- Room List Template Excel: How to Build and Use One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Import CSV Into a New Tab: Steps, Tips, and FixesTo import a CSV file into a new tab in Excel for Microsoft 365 on Windows, select Data…
- How to De-Identify Track Changes in Microsoft WordTo de-identify tracked changes in Word while keeping the edits visible, save a copy, enable Word’s personal-information removal…
- Data Link Excel to Civil 3D: Steps and LimitsTo link an Excel table into Civil 3D, create an Excel data link with the DATALINK command, then…
- Excel Consolidate Multiple Columns Into OneYes. To combine values across columns on the same row, enter a formula such as =TEXTJOIN(" ",TRUE,A2:C2) in…
- Hanging Indent in Word on Mac: A Step-by-Step GuideTo create a hanging indent in Word on a Mac, select the paragraph or paragraphs, open Format >…
- How to See Archived Emails in Outlook on Any DeviceTo see archived emails in Outlook, open the Archive folder in the folder list for the account where…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.