Question: how to change date format in excel in onedrive?
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.