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

Copper Contributor

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).