Tip of the Day | Friday 21 August 2026

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