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