New Horizons Get Schooled Blog

Change your default date separator in Excel

Change your default date separator in ExcelSome people like to use a period (.) when they separate their dates instead of a slash (/). For example, you might prefer 4.15.2012 instead of 4/15/2012. If you're tired of creating a custom number format that accommodates your desired date format, try changing Windows' default date separator.

To modify your default date separator:

  1. Click the Start menu on your Windows operating system and open the Control Panel.
  2. Double-click on Regional And Language Options to open the Regional And Language Options window.
  3. Click on the Regional Options tab and click the Customize button to display the Customize Regional Options window.
  4. Select the Date tab and choose the period from the Date Separator dropdown list.
  5. Click Apply and OK to make the change.

Important: If you change your default Windows setting to a different date separator, the change applies to all programs — not just Excel.


Learn this and more by checking out our Certified Microsoft Office Courses!

New Horizons Computer Learning Centers Excel Training and Certification

Posted on 9/10/12 5:35 PM by Get Schooled in Date Separator, in Excel, in Microsoft, in Tips & Tricks

Get Schooled

Written by Get Schooled

Search by Topic

    Lists by Topic

    see all

    Be at the center of it all.


    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.