How to correct American dates in Office365 - University of Exeter
How to correct American dates in Office365
This guide tells you how to set the Date format in online Office Web Apps to dd/mm/yyyy when they are defaulting to the American format mm/dd/yyyy, for example in Excel Online. You also need to ensure your regional settings are correct ? see section B. If you need any further assistance please contact the SID desk
A) Date format settings
1. In O365, click on the blue/white matrix menu at top left, and then click on OneDrive
2. Then click on the cogwheel at top right 3. Click on Site Settings (not Office 365 settings ).
4. This will then change the menu title to Newsfeed, don't worry about that 5. On the Site settings screen, click on Regional settings under the Site Administration block
6. You will then see the screen below
7. Make sure the Locale is set to English (United Kingdom) 8. Click OK right down at the bottom right of the screen 9. Your date fields (e.g. in Excel Online) should then be ok. You may need to re-enter the dates to pick up
the correct format
B) Timezone Regional settings
1. Open O365 Outlook and click on the Settings cogwheel at top right in the black menu bar then click on Options
2. When the Options window opens, click on General and then Region and time zone.
3. Click on the Current time zone and scroll down to (UTC) Dublin, Edinburgh, Lisbon, London 4. Then click on Save.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- using date and date time in formulas salesforce
- excel date time
- excel conditional formatting and table structures
- methodologies for converting excel spreadsheets to sas datasets
- 068 29 dating sas and ms excel
- date format excel vba silicon automation
- excel date and time math university of florida
- datetime conversion — converting strings to stata dates
- excel abbreviated date format
- working with dates times in excel
Related searches
- how to make consecutive dates in excel
- how to correct ed
- how to correct ed fast
- how to correct my sentence
- how to correct erectile problems
- how to correct erectile dysfunction without medicine
- how to correct kidney function
- how to compare two dates in excel
- how to correct a fragment sentence
- how to correct sentence fragments
- how to correct a fragment
- how to automatically add dates in excel