How to set date format between different location?
 

I have to share a workbook between French and English Canada location users.
I want the date format to respect ISO YYYY-MM-DD format independantly if you
look or print the worksheet in English or in French. But when on an English
set-up computer it changes to respect location set-up define by regional
settings and translate the date format to MM-DD-YYYY? I tried to use a Custom
formatting string but does not appear to override the regional settings? I
there any hope in what I am trying to achieve?

How to set date format between different location?
 

If your systems allows try this as a custom date format.

[$-409]yyyy-mm-dd
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Claude" wrote:

I have to share a workbook between French and English Canada location users.
I want the date format to respect ISO YYYY-MM-DD format independantly if you
look or print the worksheet in English or in French. But when on an English
set-up computer it changes to respect location set-up define by regional
settings and translate the date format to MM-DD-YYYY? I tried to use a Custom
formatting string but does not appear to override the regional settings? I
there any hope in what I am trying to achieve?

How to set date format between different location?
 

Tks Martin,
I had to adjust and translate the YYYY-MM-DD into French AAAA-MM-JJ since I
am running on a French regional setting but it worked.
What is [$-409] translate to in terms of command?
I have also some that ends with [$-409]yyyy-mm-dd;@
Do you know what it generate or control?
Where can I learn about these custom commands?
Tks

"Martin Fishlock" wrote:

If your systems allows try this as a custom date format.

[$-409]yyyy-mm-dd
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Claude" wrote:

I have to share a workbook between French and English Canada location users.
I want the date format to respect ISO YYYY-MM-DD format independantly if you
look or print the worksheet in English or in French. But when on an English
set-up computer it changes to respect location set-up define by regional
settings and translate the date format to MM-DD-YYYY? I tried to use a Custom
formatting string but does not appear to override the regional settings? I
there any hope in what I am trying to achieve?

How to set date format between different location?
 

Claude:

The [$-409] sets the language format for the date.

Not much info on it.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Claude" wrote:

Tks Martin,
I had to adjust and translate the YYYY-MM-DD into French AAAA-MM-JJ since I
am running on a French regional setting but it worked.
What is [$-409] translate to in terms of command?
I have also some that ends with [$-409]yyyy-mm-dd;@
Do you know what it generate or control?
Where can I learn about these custom commands?
Tks

"Martin Fishlock" wrote:

If your systems allows try this as a custom date format.

[$-409]yyyy-mm-dd
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Claude" wrote:

I have to share a workbook between French and English Canada location users.
I want the date format to respect ISO YYYY-MM-DD format independantly if you
look or print the worksheet in English or in French. But when on an English
set-up computer it changes to respect location set-up define by regional
settings and translate the date format to MM-DD-YYYY? I tried to use a Custom
formatting string but does not appear to override the regional settings? I
there any hope in what I am trying to achieve?

How to set date format between different location?
 

Got it, but [$-409] sets the language to what? English? If so do you know the
French equivalent code.
Moreover, I now realize that one more layer of problem I have to face is the
fact that in English, the natural habit of users inputting a date is
naturally mm-dd-yyyy and even if I set the custom date format
[$-409]yyyy-mm-dd, the command will work only if the user input it as such
but if they use natural habit of mm-dd-yyyy the cell remain as such?
So it works but do not works? I hoep you are following me and BTW thanks for
input again. If you feel I am streching it, np. Tks CR

"Martin Fishlock" wrote:

Claude:

The [$-409] sets the language format for the date.

Not much info on it.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Claude" wrote:

Tks Martin,
I had to adjust and translate the YYYY-MM-DD into French AAAA-MM-JJ since I
am running on a French regional setting but it worked.
What is [$-409] translate to in terms of command?
I have also some that ends with [$-409]yyyy-mm-dd;@
Do you know what it generate or control?
Where can I learn about these custom commands?
Tks

"Martin Fishlock" wrote:

If your systems allows try this as a custom date format.

[$-409]yyyy-mm-dd
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Claude" wrote:

I have to share a workbook between French and English Canada location users.
I want the date format to respect ISO YYYY-MM-DD format independantly if you
look or print the worksheet in English or in French. But when on an English
set-up computer it changes to respect location set-up define by regional
settings and translate the date format to MM-DD-YYYY? I tried to use a Custom
formatting string but does not appear to override the regional settings? I
there any hope in what I am trying to achieve?