Question: how to change the date format in excel online?
Answer: Login using the same account as for OneDrive / Excel Online. Go to Overview | Personal Info. Under the heading 'Home' change the country/region to the one you want as the date/currency default.