Some users have encountered a problem when sharing / collaborating on Excel documents, specifically with regards to the formatting of dates.

The UK standard of DD/MM/YYYY may be automatically switched to the US standard of MM/DD/YYYY when uploaded to the cloud – even when shared solely with others in the UK.

How does this happen?

This happens when the format below is selected – with the asterisk at the start.

The asterisk indicates that the date will be displayed according to the format of the user’s computer. However, when documents are uploaded to the cloud, they may be being shared via a US-based server – so the format is getting picked up from this location, as opposed to the computer it is being viewed on.

How can I fix this?

Luckily, there is an easy way to work around this. Simply select the date format without the asterisk, and the date format will stay the same.