Date format French/Us english

%3CLINGO-SUB%20id%3D%22lingo-sub-1632556%22%20slang%3D%22fr-FR%22%3EDate%20format%20French%2FUs%20english%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1632556%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20several%20Excel%20files%20ZIPed%20together.%3C%2FP%3E%3CP%3EAll%20files%20have%20a%20French%20chart%20and%20and%20an%20English%20chart.%20%3CBR%20%2F%3E%20The%20French%20chart%20has%20bottom%20dates%20like%20%22July%20-2019%22%20and%20English%20ones%20like%20%22Jul-2019%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20once%20I%20receive%20the%20same%20ZIP%2C%20when%20I%20open%20the%20charts%2C%20all%20the%20English%20dates%20switch%20to%20French%20Format%20(because%20I%20guess%20I'm%20in%20France)%2C%20but%20I%20want%20to%20keep%20the%20English%20date%20format%20on%20English%20charts.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20do%20not%20have%20time%20to%20go%20on%20each%20English%20chart%2C%20double%20click%20on%20bottom%20date%20to%20change%20format%2C%20as%20I%20have%20about%2030%20to%2060%20charts%20to%20deal%20within%2030%20minutes.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Is%20there%20a%20solution%20to%20force%20Excel%20to%20keep%20the%20English%20date%20format%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20applies%20to%20Office%20365%20and%20Pack%20office%202010.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1632556%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi ! 

 

I have several Excel files ZIPed together.

All files have a French chart and and an English chart.
The French chart has bottom dates like " Juil -2019" and English ones like "Jul-2019".

 

But once  I receive the same ZIP, when I open the charts, all the English dates switch to French Format (because I guess I'm in France), but I want to keep the English date format on English charts.

I do not have time to go on each English chart, double clic on bottom date to change format, as I have about 30 to 60 charts to deal within 30 minutes.

Is there a solution to force Excel to keep the English date format ? 

This applies to Office 365 and Pack office 2010.

 

Thank you

0 Replies