How to correct American dates in Office365
[Pages:4]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
- mrs temoshok s lesson plan
- general information and application instructions
- tennessee home vegetable garden
- your personal blue zone aarp
- yearly let s get your plan on
- zoneplanner ruckus networks
- zone 9 vegetable calendar
- how to correct american dates in office365
- using scheduler for enhanced time attendance
- oracle real time scheduler 1 13
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