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