Tip of the Day | Friday 21 August 2026

Discover new tools to get things done.

Display Regional Settings Used by Excel (Separators & Date Format)

This tool displays the regional settings Excel currently uses on your system.
It shows:

  • Decimal separator (e.g., period or comma)
  • Thousand separator (e.g., comma, period or space)
  • List separator (e.g., comma or semicolon)
  • Date separator (e.g., slash, dot, or hyphen)
  • Date format order (e.g., day-month-year, month-day-year)

These settings affect how Excel displays and interprets numbers, formula arguments, and dates.

Knowing your current settings is important because mismatched or unexpected separators can lead to:

  • Incorrectly imported CSV or TXT files
  • Formula errors or miscalculations
  • Dates being misinterpreted (e.g., 03-04-2025 as March 4 or April 3)

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Tip:Alt+P for the previous tool.