On Mon, 15 Aug 2005 04:11:57 -0500, 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.

You could store the dates as TEXT rather than as Excel dates.

Or you could use a different algorithm to filter your records.

Excel stores dates as serial numbers with 1=1/1/1900 or 1/2/1904 depending on
the date system in use. How it is displayed in the workbook does not affect
what has been previously stored in the cell. How it is parsed when entered
into the workbook is affected by the Windows regional settings.

Perhaps if you give more detail? ...


--ron