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 |
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 |
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 |
All times are GMT +1. The time now is 10:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com