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?