Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
Can't change x-axis labels | Charts and Charting in Excel | |||
Change value in cell | Excel Discussion (Misc queries) | |||
Find function | Excel Worksheet Functions | |||
Find function | Excel Worksheet Functions |