Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formating
If there is a date format, which is set-up as UK format but my computer is
set-up as US region (due to the systems i use) is there a way of converting this? Date format is 12-21-2006 etc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formating
Try selecting the cell and right-clicking then going to 'Format Cell'.
Once there, head to the 'Number' tab and select 'Date'. From there, you will see 3 boxes on the right side of that dialog box; Sample, Type, and Locale. Select the locale 'English (United Kingdom)', that will only effect the cells that you have selected and not the rest of the sheet when you put a date in there. theSquirrel Hawksby wrote: If there is a date format, which is set-up as UK format but my computer is set-up as US region (due to the systems i use) is there a way of converting this? Date format is 12-21-2006 etc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formating
Format cells as: dd-mm-yyyy
"Hawksby" wrote: If there is a date format, which is set-up as UK format but my computer is set-up as US region (due to the systems i use) is there a way of converting this? Date format is 12-21-2006 etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel date scheduling not msProject | Excel Worksheet Functions | |||
How to return a value between date ranges | Excel Worksheet Functions | |||
Help with date formating when export to Word | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Formating decimal and date | Excel Worksheet Functions |