Toggle Help Topics Menu >

Change Date Formats

Changes the date format for any cell containing a date in the selected range.

Form Fields

  • Range: Select the range to change the formatting. (This field is preset with the selected range when the form is opened.)
  • Output format: A dropdown list of common date formats. See Date Formats for details.
  • Date separator: choose from dash, slash, dot, or space ("-", "/", ".", or " ").
  • Use localized day and month names: Uses the built-in Excel localized names based on your system settings.