--- title: Language Settings and Excel Date Fixes description: How to fix language issues and date issues in Excel --- [Skip to content](https://support.axiosint.com/knowledge/language-settings-and-date-fixes#main-content) [More support](https://support.axiosint.com/knowledge/kb-tickets/new?hsLang=en) [![Digital University Logo](https://support.axiosint.com/hs-fs/hubfs/DU-logo-2.png?width=182&height=120&name=DU-logo-2.png)](https://support.axiosint.com/knowledge?hsLang=en) Open main navigation Close main navigation - [More support](https://support.axiosint.com/knowledge/kb-tickets/new) - [Go to axiosint.com](https://axiosint.com/) [Go to axiosint.com](https://axiosint.com/) Welcome to Axios Digital University. - There are no suggestions because the search field is empty. 1. [Axios Digital University](https://support.axiosint.com/knowledge?hsLang=en) 2. [PMS User Guide](https://support.axiosint.com/knowledge/pms-user-guide?hsLang=en) 3. [General Knowledge](https://support.axiosint.com/knowledge/pms-user-guide?hsLang=en#general-knowledge) # Language Settings and Excel Date Fixes ## Read this article if your are facing issues with the date formatting in Excel #### Table of contents [Languages Settings](https://support.axiosint.com/knowledge/language-settings-and-date-fixes#language) [Excel Date Fixes](https://support.axiosint.com/knowledge/language-settings-and-date-fixes#date) ---   ### Language Settings Look at your taskbar right now and you’ll probably see “ENG” depending on your machine’s selected language. Clicking that will open the language options available on your laptop. You should have the English (United Kingdom) option selected as that matches the locale used on PMS. ![](https://support.axiosint.com/hs-fs/hubfs/image-png-Jun-16-2023-08-42-54-1831-AM.png?width=243&height=201&name=image-png-Jun-16-2023-08-42-54-1831-AM.png) If you don’t have the UK option available, simply click on Language Preferences as shown to the right and add it via the “Add a language” option in the Settings window that pops up. ![](https://support.axiosint.com/hs-fs/hubfs/image-png-Jun-16-2023-08-44-39-3643-AM.png?width=488&height=149&name=image-png-Jun-16-2023-08-44-39-3643-AM.png) Aside from the keyboard option, the “Regional Settings” of your device is an integral part of this process as well (Excel actually uses this to drive its format). - Open your Start menu and type the phrase “Region Settings” - Press Enter on the first option that comes up, it should look like this: ![](https://support.axiosint.com/hs-fs/hubfs/image-png-Jun-16-2023-08-46-09-4419-AM.png?width=251&height=73&name=image-png-Jun-16-2023-08-46-09-4419-AM.png) - The Region window should pop up allowing you to change your country/region, the regional format you want your system to use, and the regional format you want regarding dates. **![important](https://support.axiosint.com/hubfs/important.svg)IMPORTANT** You may need to restart your device for these changes to take effect. **![note](https://support.axiosint.com/hubfs/note.svg)Good to know** For those using online versions of MS Office, you’ll need to go to **[https://www.office.com](https://www.office.com/) \> Settings cog wheel (top right) \> “Language and time zone”**, then update there.   **[Back to Top](https://support.axiosint.com/knowledge/language-settings-and-date-fixes#top)** ---   ### Excel Date Fixes  **“It's the Date that’s wrong, not me”** 1. In Excel, select your problematic column 2. Find the “Number” submenu under the Home tab and click on the dropdown ![](https://support.axiosint.com/hs-fs/hubfs/image-png-Jun-16-2023-08-55-56-3103-AM.png?width=506&height=156&name=image-png-Jun-16-2023-08-55-56-3103-AM.png) 3. Upon clicking the dropdown, you’ll be met with many options to set your data type. Either Select “Short Date” or “Long Date” depending on your preference and your data should now be uniform. ![](https://support.axiosint.com/hs-fs/hubfs/image-png-Jun-16-2023-08-56-15-7143-AM.png?width=194&height=94&name=image-png-Jun-16-2023-08-56-15-7143-AM.png) 4. Alternatively, you can select the “More Number Formats” Option, which will allow you to select specific date configurations as well as the date locale you’d like the dates to be in.  ![](https://support.axiosint.com/hs-fs/hubfs/image-png-Jun-16-2023-08-56-43-3756-AM.png?width=186&height=105&name=image-png-Jun-16-2023-08-56-43-3756-AM.png) ![](https://support.axiosint.com/hs-fs/hubfs/image-png-Jun-16-2023-08-58-08-9220-AM.png?width=450&height=263&name=image-png-Jun-16-2023-08-58-08-9220-AM.png)   **[Back to Top](https://support.axiosint.com/knowledge/language-settings-and-date-fixes#top)** --- ![further](https://support.axiosint.com/hubfs/further.svg) **Going Further** Want to learn more **useful information for your day to day work**? Make sure to check our [Productivity Tips](https://support.axiosint.com/knowledge/productivity-tips?hsLang=en) article and the [Expectations & Best Practices](https://support.axiosint.com/knowledge/data-is-king?hsLang=en) article.     - [PMS User Guide](https://support.axiosint.com/knowledge/pms-user-guide?hsLang=en#main-content) - [Glossary & Definitions](https://support.axiosint.com/knowledge/pms-user-guide?hsLang=en#glossary-definitions) - [General Knowledge](https://support.axiosint.com/knowledge/pms-user-guide?hsLang=en#general-knowledge) - [Program Configuration](https://support.axiosint.com/knowledge/pms-user-guide?hsLang=en#program-configuration) - [Program Management](https://support.axiosint.com/knowledge/pms-user-guide?hsLang=en#program-management) - [Patient Management](https://support.axiosint.com/knowledge/pms-user-guide?hsLang=en#patient-management) - [Entity Management](https://support.axiosint.com/knowledge/pms-user-guide?hsLang=en#entity-management) - [Axios+ User Guide](https://support.axiosint.com/knowledge/axios-user-guide?hsLang=en#main-content) - [MyPrograms](https://support.axiosint.com/knowledge/axios-user-guide?hsLang=en#myprograms) - [MyPatients](https://support.axiosint.com/knowledge/axios-user-guide?hsLang=en#mypatients) - [MyHealth](https://support.axiosint.com/knowledge/axios-user-guide?hsLang=en#myhealth) - [MyHealth (v2)](https://support.axiosint.com/knowledge/axios-user-guide?hsLang=en#myhealth-v2) - [MyPharmacy (Mobile App)](https://support.axiosint.com/knowledge/axios-user-guide?hsLang=en#mypharmacy-mobile-app) - [MyPharmacy (Desktop App)](https://support.axiosint.com/knowledge/axios-user-guide?hsLang=en#mypharmacy-desktop-app) - [Digital University Sessions](https://support.axiosint.com/knowledge/digital-university-sessions?hsLang=en#main-content) - [Season 1](https://support.axiosint.com/knowledge/digital-university-sessions?hsLang=en#season-1) - [Season 2](https://support.axiosint.com/knowledge/digital-university-sessions?hsLang=en#season-2) - [Season 3](https://support.axiosint.com/knowledge/digital-university-sessions?hsLang=en#season-3) - [Season 4](https://support.axiosint.com/knowledge/digital-university-sessions?hsLang=en#season-4) - [Season 5](https://support.axiosint.com/knowledge/digital-university-sessions?hsLang=en#season-5) - [Season 6](https://support.axiosint.com/knowledge/digital-university-sessions?hsLang=en#season-6) - [Season 7](https://support.axiosint.com/knowledge/digital-university-sessions?hsLang=en#season-7) - [FAQ PMS](https://support.axiosint.com/knowledge/faq-pms?hsLang=en#main-content) - [Access Management](https://support.axiosint.com/knowledge/faq-pms?hsLang=en#access-management) - [Data, Statistics and Reporting](https://support.axiosint.com/knowledge/faq-pms?hsLang=en#data-statistics-and-reporting) - [Entity Management](https://support.axiosint.com/knowledge/faq-pms?hsLang=en#entity-management) - [Patient Management](https://support.axiosint.com/knowledge/faq-pms?hsLang=en#patient-management) - [Program Management](https://support.axiosint.com/knowledge/faq-pms?hsLang=en#program-management) - [Treatment Management](https://support.axiosint.com/knowledge/faq-pms?hsLang=en#treatment-management) - [FAQ Axios+](https://support.axiosint.com/knowledge/faq-axios?hsLang=en#main-content) - [General](https://support.axiosint.com/knowledge/faq-axios?hsLang=en#general) - [General - Account Creation and Management](https://support.axiosint.com/knowledge/faq-axios?hsLang=en#general-account-creation-and-management) - [General - App Installation and Features](https://support.axiosint.com/knowledge/faq-axios?hsLang=en#general-app-installation-and-features) - [MyHealth](https://support.axiosint.com/knowledge/faq-axios?hsLang=en#myhealth) - [MyHealth (Adherence)](https://support.axiosint.com/knowledge/faq-axios?hsLang=en#myhealth-adherence) - [MyPatients](https://support.axiosint.com/knowledge/faq-axios?hsLang=en#mypatients) - [MyPharmacy](https://support.axiosint.com/knowledge/faq-axios?hsLang=en#mypharmacy) - [MyPrograms](https://support.axiosint.com/knowledge/faq-axios?hsLang=en#myprograms) - [FAQ Digital Knowledge](https://support.axiosint.com/knowledge/faq-digital-knowledge?hsLang=en#main-content) - [Technical Knowledge](https://support.axiosint.com/knowledge/faq-digital-knowledge?hsLang=en#technical-knowledge) - [Security Best Practices](https://support.axiosint.com/knowledge/faq-digital-knowledge?hsLang=en#security-best-practices) - [Internal Processes](https://support.axiosint.com/knowledge/internal-processes?hsLang=en#main-content) - [Process Sheet](https://support.axiosint.com/knowledge/internal-processes?hsLang=en#process-sheet) - [Technical Documentation](https://support.axiosint.com/knowledge/internal-processes?hsLang=en#technical-documentation) - [Generative AI](https://support.axiosint.com/knowledge/internal-processes?hsLang=en#generative-ai) [![Chill listening crop-3](https://support.axiosint.com/hs-fs/hubfs/2.%20Axios%20Master%20logo%20without%20tagline.png?width=70&height=32&name=2.%20Axios%20Master%20logo%20without%20tagline.png "Chill listening crop-3")](http://axiosint.com) Axios Digital University Copyright © 2026, Axios International