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

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