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.