how do i need to configure languages/location of my pc to work with american dates format?

%3CLINGO-SUB%20id%3D%22lingo-sub-1930420%22%20slang%3D%22en-US%22%3Ehow%20do%20i%20need%20to%20configure%20languages%2Flocation%20of%20my%20pc%20to%20work%20with%20american%20dates%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1930420%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20college%20shared%20an%20excel%20woorkbook%20with%20me%20and%20it%20is%20not%20working%20because%20he%20has%20it%20configured%20with%20american%20dates%20mm%2Fdd%2Fyyyy.%26nbsp%3B%20My%20excel%20works%20fine%20with%20format%20dd%2Fmm%2Fyyyy%20(i%20am%20located%20in%20spain).%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EWhen%20I%20try%20to%20use%20the%20formula%20TEXT(a2%2C%22DDD)%20it%20shows%20the%20short%20day%20of%20the%20week%20in%20spanish%20and%20i%20needed%20it%20in%20english.%20OF%20course%2C%20when%20the%20date%20doesn't%20exist%20in%20spanish%20format%2C%20the%20formula%20doesn't%20retrieve%20anything%20(example%20if%20i%20put%2003%2F14%2F2020%20it%20won't%20return%20anything%20as%20this%20in%20spanish%20format%20would%20mean%20month%2014).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20should%20I%20change%20in%20my%20laptop%20to%20work%20with%20this%20excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1930420%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1930648%22%20slang%3D%22en-US%22%3ERe%3A%20how%20do%20i%20need%20to%20configure%20languages%2Flocation%20of%20my%20pc%20to%20work%20with%20american%20dates%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1930648%22%20slang%3D%22en-US%22%3EIn%20Windows%20Settings%2C%20Time%20%26amp%3B%20Language%2C%20set%20your%20Regional%20format%20to%20English%20(United%20States).%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

A college shared an excel woorkbook with me and it is not working because he has it configured with american dates mm/dd/yyyy.  My excel works fine with format dd/mm/yyyy (i am located in spain).


When I try to use the formula TEXT(a2,"DDD) it shows the short day of the week in spanish and i needed it in english. OF course, when the date doesn't exist in spanish format, the formula doesn't retrieve anything (example if i put 03/14/2020 it won't return anything as this in spanish format would mean month 14). 

 

What should I change in my laptop to work with this excel?

 

2 Replies
In Windows Settings, Time & Language, set your Regional format to English (United States).