Here’s a clear, practical “Quick Scoop” guide on how to change date format in Excel , plus some extra tips and pitfalls to watch out for.

How to Change Date Format in Excel

Changing the date format in Excel mainly comes down to two things:

  • Making sure Excel recognizes your values as real dates (not text).
  • Applying the right built‑in or custom date format.

1. Quick way: Built‑in date formats

Use this when your dates are already recognized correctly (you can test by changing the format and the value changes, not the text).

Steps (works in modern Excel on Windows/Mac)

  1. Select the cells that contain your dates.
  2. Press Ctrl + 1 (or Cmd + 1 on Mac) to open Format Cells.
  3. Go to the Number tab.
  4. Click Date in the Category list.
  5. In Type , choose a format you like, such as:
    • 14/03/2012
    • 03/14/12
    • 14-Mar-12
    • March 14, 2012
  6. Optionally change Locale (location) so Excel offers formats for a specific region (e.g., English (United States) vs English (United Kingdom)).
  7. Click OK.

That’s it—the underlying date stays the same; only the display changes.

2. Popular shortcuts (fast formatting)

If you like keyboard shortcuts:

  • Short Date :
    Select cells → press Alt → H → N (or in some setups Alt + H + 4) to apply a short date style like 2/6/2020.

  • Long Date :
    Select cells → Alt → H → L (or Alt + H + 5 in some layouts) to switch to something like Thursday, February 6, 2020.

  • Common custom look (dd‑mmm‑yy) :
    Select cells → press Ctrl + Shift + # to apply a format like 01-Jan-25.

Exact key sequences can vary slightly with Excel version and language, but these are standard patterns.

3. Custom date formats (DD/MM/YYYY, YYYY‑MM‑DD, etc.)

If the default list doesn’t show what you want, use Custom.

Steps

  1. Select the date cells.
  2. Ctrl + 1 / Cmd + 1 → Number tab.
  3. Click Custom.
  4. In Type , enter a format code such as:
    • dd/mm/yyyy → 05/07/2025
    • mm/dd/yyyy → 07/05/2025
    • dd-mmm-yyyy → 05-Jul-2025
    • mmmm d, yyyy → July 5, 2025
    • ddd, dd-mmm → Sat, 05-Jul

Useful pieces you can combine:

  • d = day (1–31)
  • dd = day with leading zero (01–31)
  • ddd = short weekday (Mon, Tue)
  • dddd = full weekday (Monday, Tuesday)
  • m = month number (1–12)
  • mm = month with leading zero (01–12)
  • mmm = short month (Jan, Feb)
  • mmmm = full month (January, February)
  • yy = two‑digit year
  • yyyy = four‑digit year

You can mix them with dashes, slashes, commas, and text.

4. Dates showing as text (when format seems “stuck”)

If changing the format doesn’t visually change the values, Excel is likely treating them as text , not dates. Common symptoms:

  • Values aligned left (by default) while real numbers/dates are right‑aligned.
  • An error indicator, or formulas like =TODAY() not working well with them.
  • Formats don’t change the appearance.

Typical causes

  • Imported data (CSV, system export) in formats like 2025-07-05 or 05.07.2025 that Excel doesn’t auto‑recognize for your region.
  • Dates copied from web pages or systems where they’re stored as text.

Fix strategies

  1. Text to Columns trick

    • Select the problematic column.
    • Go to Data → Text to Columns.
    • Choose Delimited → Next → Next.
    • In Column data format , choose Date and pick the pattern that matches your data (e.g., DMY for 05/07/2025, MDY for 07/05/2025, YMD for 2025-07-05).
    • Click Finish.

  2. DATE and TEXT functions (formula method)
    If your dates are consistent strings, you can rebuild real dates:

    • Suppose text 05/07/2025 is in A2 and it’s really DD/MM/YYYY:
      • Use =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2))
    • Then fill down and format that new column as a date.

  3. Check regional settings if nothing works
    When Excel expects MM/DD/YYYY but you have DD/MM/YYYY, it can misinterpret or reject dates. Sometimes adjusting Windows/macOS regional short date settings (or the workbook’s locale) helps.

5. Showing dates as text in a specific style

Sometimes you don’t need a “true” date format; you just want a nice text output (for emails, invoices, etc.). Use the TEXT function:

  • =TEXT(A2, "dd/mm/yyyy") → 05/07/2025
  • =TEXT(A2, "dddd, mmmm d, yyyy") → Saturday, July 5, 2025
  • ="Due on: " & TEXT(A2, "dddd, mmmm d") → Due on: Saturday, July 5

This is great when combining dates with other text, but remember:

  • TEXT returns text, so you can’t easily sort or calculate like with real date values.

6. Regional formats and international work

If you share files with people in different countries, you’ll probably run into:

  • US style: MM/DD/YYYY (e.g., 07/05/2025).
  • European style: DD/MM/YYYY (e.g., 05/07/2025).

Tips:

  • Prefer unambiguous formats like dd-mmm-yyyy (05-Jul-2025) when sending files internationally.
  • Consider using ISO style yyyy-mm-dd (e.g., 2025-07-05) for logs and datasets; it sorts nicely in text form and is clear.

7. Little “story” example

Imagine you get a report from a US colleague with dates like 07/05/2025, and you’re used to day‑month‑year.

  1. You open the file, and Excel (with your European settings) might already interpret 07/05/2025 as 7 May 2025.
  2. But the colleague meant July 5, 2025.
  3. To avoid confusion, you:
    • Change the format to dd-mmm-yyyy so you see 05-Jul-2025 or 07-May-2025 clearly and catch inconsistencies.
    • Or you agree that all shared files will use dd-mmm-yyyy or yyyy-mm-dd so nobody misreads the dates again.

That tiny formatting choice can save a lot of scheduling headaches.

8. HTML table of common date formats

Here’s a handy HTML table you can reuse:

html

<table>
  <thead>
    <tr>
      <th>Format code</th>
      <th>Example output</th>
      <th>Notes</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>dd/mm/yyyy</td>
      <td>05/07/2025</td>
      <td>Day first, then month and year.</td>
    </tr>
    <tr>
      <td>mm/dd/yyyy</td>
      <td>07/05/2025</td>
      <td>US-style month first.</td>
    </tr>
    <tr>
      <td>dd-mmm-yyyy</td>
      <td>05-Jul-2025</td>
      <td>Short month name, avoids ambiguity.</td>
    </tr>
    <tr>
      <td>mmmm d, yyyy</td>
      <td>July 5, 2025</td>
      <td>Long, reader-friendly format.</td>
    </tr>
    <tr>
      <td>ddd, dd-mmm</td>
      <td>Sat, 05-Jul</td>
      <td>Shows weekday without year.</td>
    </tr>
    <tr>
      <td>yyyy-mm-dd</td>
      <td>2025-07-05</td>
      <td>ISO-like; great for sorting.</td>
    </tr>
  </tbody>
</table>

TL;DR

  • Use Format Cells → Date for quick changes.
  • Use Custom and codes like dd/mm/yyyy or yyyy-mm-dd for precise control.
  • If formatting “does nothing,” your data is probably text , so convert it to real dates first (Text to Columns or formulas).
  • For sentences like “Due on: Friday, July 5, 2025,” use the TEXT function.

If you tell me your current date format and what you want it to look like (plus your Excel version and region), I can walk you through the exact steps for your scenario.