Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
EASY cond format Date?? | Excel Discussion (Misc queries) | |||
MS Query Date Format | Excel Discussion (Misc queries) | |||
Customized Date Format | Excel Worksheet Functions |