ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I change from american dating to uk dating? (https://www.excelbanter.com/excel-worksheet-functions/120405-how-do-i-change-american-dating-uk-dating.html)

Ile Esturo

How do I change from american dating to uk dating?
 
I want to change 11/14/2006 17:57 to 14/11/2006 17:57. How do I do it? Please
help fast!!!

Don

How do I change from american dating to uk dating?
 
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.



"Ile Esturo" wrote:

I want to change 11/14/2006 17:57 to 14/11/2006 17:57. How do I do it? Please
help fast!!!



All times are GMT +1. The time now is 06:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com