Tips&Tricks Microsoft Windows

Date&Time and Number Formats

Problem: Excel and other programs use non-preferred format for dates and numbers…

Solution: It must be set system-wide - go to Windows settings via Control Panel → Region & Languages

Details:

Set preffered date and number format via dialog:

Windows Menu Start → Control Panel → Region & Languages →

windows-regional-settings-01.jpg

And “Additional settings”:

windows-regional-settings-02.jpg