Change Date Formats
Changes the date format for any cell containing a date in the selected range.
- 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.