Highlight the date (or column/row of dates) that you want to change (re-format)
On the menu, Format ---> Cells
On the right side of the window, you will see sample, type, and Locale
Use the dropdown menu to change the Locale from English (United States) to
English (United Kingdom) and then choose from the Type in the box above.
Review the Sample pane to see if that is what you want.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.