This has more to do with the Date Settings on the user's Regional Options
than your worksheet formats. However, you can counter this by customizing
the cell format using Format Cells>Number>Custom. I'm not sure what UK format
is but here are a few examples using "01 Jan 2005" you can work with...

dd = 01, ddd = Sat, dddd = Saturday
mm = 01, mmm = Jan, mmmm = January
yy = 05, yyyy = 2005

You can also display dividors by entering them in the format...
dd-mmm-yyyy returns 01-Jan-2005
dd-mmmm-yyyy returns 01-January-2005
ddd-dd-mmmm-yyyy returns Sat-01-January-2005



"jarvo" wrote:

hi,

Is it possible to stop excel changing the date format when it is opened
in another region. i.e from UK to US.

i have created a template that is used by several people in different
regions, it uses the UK date format for filtering records by date.

However when the template is opened in another region (ie USA) the
dates change format, to the region (locale) set on the users computer.
This stops the template working as intended.

so i want the dates to stay in the UK format no matter where they are
opened.

thanks.


--
jarvo
------------------------------------------------------------------------
jarvo's Profile:
http://www.excelforum.com/member.php...o&userid=18983
View this thread: http://www.excelforum.com/showthread...hreadid=395748