To display dates in American month/day/year order in Excel, select the date cells, press Ctrl+1, choose a date format such as MM/DD/YYYY, and select English (United States) if Excel offers a locale setting. This changes how real date values appear; it does not necessarily convert dates stored as text or resolve ambiguous imported dates. The steps below are for Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook with the dates you want to change. Save a copy first if the data is important, especially before converting imported text.
- A clear idea of the intended order in the source data. American dates put the month first, so 04/05/2026 means April 5, 2026, not May 4.
- Excel for Microsoft 365 on Windows for the main instructions. Excel for Mac and Excel for the web have similar formatting controls, with interface differences noted below.
Step-by-Step
- Select the cells you want to format. Click and drag over a date range, or click a column letter to select the whole column. To select non-adjacent ranges, hold Ctrl while selecting each range. If you select an entire column, remember that the format will also apply to dates entered there later. Avoid selecting unrelated numbers, because a date format can make ordinary numbers appear as dates.
- Open the Format Cells dialog. Press Ctrl+1 on Windows. Alternatively, go to Home > Number and click the small dialog box launcher at the lower-right of the Number group. The dialog lets you set a format for the selected cells without changing the underlying date values.
- Choose a U.S. date locale. On the Number tab, select Date in the Category list. If the Locale (location) list is available, choose English (United States). The sample preview should show month first. Locale affects the date patterns offered in the list; it does not change the computer’s regional settings. If you do not see a locale list, use the Custom option in the next step to specify the pattern directly.
- Pick the date style you want. In the Type list, look for a month-first pattern such as 3/14/2012, then check the Sample preview. This built-in style commonly displays a one- or two-digit month and day without forcing leading zeroes. If you specifically want two digits for both, such as 03/04/2026, use a custom format instead.
- Set an exact format if needed. In the Format Cells dialog, select Custom. In the Type box, enter
mm/dd/yyyyfor a four-digit year and two digits each for month and day. For example, April 5, 2026 displays as 04/05/2026. Choosem/d/yyyyif you prefer 4/5/2026 without leading zeroes. Click OK to apply the format. - Check a few results. Compare the displayed dates with records whose meaning you know. A real Excel date is usually stored as a number, even though it displays as a date. You can click a formatted cell and look at the formula bar; the date should still be represented as a date value, not merely a string of characters. Changing the display should not alter the order of the underlying day, month, and year.
- Apply the format to additional date cells if needed. Repeat the selection and formatting steps for other ranges, or use Format Painter on the Home tab to copy the formatting. Format Painter copies other cell formatting too, so check the destination for unwanted font, fill, or border changes. If you want new entries in a table column to follow the same style, format the column or table date field rather than only a few existing cells.
Excel for Mac: Select the cells and open Format > Cells, then use the Number tab to choose Date or Custom. The dialog layout can vary slightly by release. If a shortcut is more convenient, check the shortcut shown in your Excel menus; Windows Ctrl+1 is not the same as assuming a Windows keyboard on a Mac. Excel for the web: select the cells, then use Home > Number Format and choose More Number Formats if shown. Choose a date category or custom format. If the web interface does not offer the exact locale or custom pattern you need, open the workbook in the desktop app and set it there.
Common Mistakes
- Expecting formatting to fix text. A cell containing the text 04/05/2026 may not respond to a date number format. Excel formats stored values; it does not automatically reinterpret every text string as a date. Imported CSV files and pasted data often contain text dates.
- Confusing display order with date meaning. If Excel has already interpreted 04/05/2026 as April 5, changing the display to a different pattern will not turn it into May 4. The stored date is already a specific day. Confirm the intended meaning before converting an ambiguous source.
- Using the wrong pattern for the desired appearance.
m/d/yyyyandmm/dd/yyyyboth put month first, but only the second forces leading zeroes. A format with a two-digit year, such asmm/dd/yy, can be less clear when dates span different centuries. - Formatting the entire worksheet unnecessarily. Applying a date format to a large area can make zeroes or unrelated numeric values appear as dates. Select only the relevant date cells or column.
- Assuming a format changes every workbook setting. Cell formatting is generally saved with the workbook and affects the selected cells. It does not necessarily change how other workbooks or other users’ computers display dates.
Tips
- Choose a format for the audience. MM/DD/YYYY is familiar in the United States, but it can be misread in countries that put the day first. For reports shared internationally, consider a written month, such as 05-Apr-2026, or an unambiguous year-first format such as 2026-04-05.
- Keep the four-digit year. A four-digit year makes the date clearer in printed reports and older records, and avoids uncertainty about how a two-digit year should be interpreted.
- Use the preview before confirming. The Sample area in Format Cells shows how the currently selected value will appear. If it is blank or displays an unexpected result, the selection may contain text, blanks, or values that are not valid dates.
- Separate date display from date entry. A cell format controls the appearance of a value, but Excel’s interpretation of a typed date can depend on regional settings. When entering dates manually, use an unambiguous method, such as selecting a date from a controlled input process, and verify the result.
- Preserve the original import when meaning is uncertain. Keep a copy of the source column before converting it. This makes it possible to compare the original text with the converted dates and catch month/day reversals before using the data in calculations or reports.
Troubleshooting
The cells do not change after I choose MM/DD/YYYY. Check whether the values are stored as text. A quick clue is that changing the number format has no visible effect, or the entries are left-aligned by default, though alignment alone is not proof. If the source is text and its order is known, select the column and use Data > Text to Columns. In the wizard, choose Delimited and click Next, then click Next again. Under Column data format, choose Date and select MDY for month/day/year source text, then click Finish. Choose the source order that the text actually uses; do not choose MDY just because you want an American-looking display. Test on a copy or a small sample first.
The date changes to a different day or month. Stop and undo the conversion if you can. Check the original source convention and a known example. For instance, 04/05/2026 is ambiguous without context: it could mean April 5 or May 4. A display format cannot recover the intended meaning once ambiguous text has been interpreted incorrectly. Re-import or reconvert from the untouched source with the correct order selected.
I see ##### instead of a date. The column is usually too narrow to show the formatted value. Widen it by dragging the right edge of the column heading, or double-click that edge to AutoFit. The date may also be a negative date/time result or an out-of-range value in some workbook systems; check the underlying value and formula if widening does not help.
The date shows a serial number. The value may be a valid Excel date that is currently formatted as General or Number. Apply the date format again. Excel stores dates as serial values so they can be used in calculations; the serial is not necessarily evidence of damaged data.
New dates still appear in another style. Confirm that you formatted the cells where the new values are being entered. Also check whether the entry is text, whether a pasted cell brought its own formatting, and whether a table or workbook style is affecting the appearance. Reapply the desired format to the destination cells after pasting. If the date is being created by an imported file or external system, check that system’s output and the workbook’s regional assumptions as well.
Frequently Asked Questions
What is the American date format in Excel?
The common U.S. order is month, day, year: MM/DD/YYYY. For example, July 9, 2026 can display as 07/09/2026. Excel can also show the same date with one-digit month or day, or with a written month name.
Does changing the format convert a date from day/month/year to month/day/year?
Not by itself. Formatting changes the way an existing date value is displayed. If Excel already interpreted the date, the underlying day remains the same. If the source is text, convert it using the correct source order before applying the desired display format.
How do I make Excel show leading zeroes?
Select the cells, open Format Cells with Ctrl+1 on Windows, choose Custom, and enter mm/dd/yyyy. This displays a one-digit month or day with a leading zero, such as 02/09/2026.
Can I make American dates the default for every workbook?
Formatting selected cells changes those cells, not every workbook on the computer. Excel’s default date choices can also reflect regional settings. To keep a preferred style for future files, format a workbook template or create new workbooks from a template with the date columns already formatted.
Why does Excel display dates differently on another computer?
The cell format may be tied to a locale or interpreted differently by an application, and the other computer may use different regional settings. A custom pattern such as mm/dd/yyyy can make the intended display explicit in Excel, but check the result in the software and locale used by the recipient.
Can I use MM/DD/YYYY in Excel for the web?
Usually, yes. Select the cells and use Home > Number Format to choose a date option or More Number Formats. If the web version does not expose the exact custom format or locale control you need, set it in Excel for Windows or Mac, then save the workbook.
Related
- Average Hours and Minutes in Excel: A Step-by-Step Guide
- How to Autofit in Microsoft Excel: Rows and Columns
- Autofit Row Height in Excel: The Keyboard Shortcut
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Value Formatting: What It Changes and How to Use ItIn Excel, value formatting changes how a stored number, date, or text value appears in a cell; it…
- How to Set Out of Office in the Outlook Mobile AppTo set an out-of-office reply in Outlook mobile, open the app’s Settings, select the email account, choose Automatic…
- Watermark in a Word Table: Add One Without Hiding TextTo watermark only a table in Word, insert WordArt, set it to a pale color, choose Shape Format…
- Power Query in Google Sheets: What Works and What Doesn’tNo, Google Sheets does not include Microsoft Power Query or a built-in Power Query Editor. You can still…
- How to Share a Resource Calendar in Microsoft OutlookTo share a room or equipment calendar in Outlook, open the calendar’s sharing or permissions controls, add the…
- How to Check Save History in ExcelTo check save history in Excel for Microsoft 365 on Windows, open the workbook and select File >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.