Forum Discussion
Date format
Hello all,
I have created an excel file for my team. We share the file in a group on Teams and everybody has access to update the file online.
One of the columns is date and the format I selected is dd/mm/yyyy. The date format is different for some of my colleagues (they can see the dates in that column in the american format).
Checking online, it seems that, because the excel file is online, the date format changes based on the machine/Teams set up.
Is there a way to fix it, to lock the format, without asking everybody in my team to make changes to their machines?
Thank you!
In the Format Cells dialog, Number tab, if you select Date, you'll notice that the first two formats are marked with an asterisk:
These are the Short Date and Long Date formats of the system running Excel. Excel will automatically change them on other computers. Moreover. Excel Online always uses the local settings, even if the computer has another regional setting.
If you set the format to the custom format dd\/mm\/yyyy or dd"/"mm"/"yyyy, Excel should leave it unchanged on other computer.
8 Replies
In the Format Cells dialog, Number tab, if you select Date, you'll notice that the first two formats are marked with an asterisk:
These are the Short Date and Long Date formats of the system running Excel. Excel will automatically change them on other computers. Moreover. Excel Online always uses the local settings, even if the computer has another regional setting.
If you set the format to the custom format dd\/mm\/yyyy or dd"/"mm"/"yyyy, Excel should leave it unchanged on other computer.
Hi, I Have a similar problem. Independently by the format online, when I paste a date from online into my PC (in another excel file), it is transformed into a general format (not a date). And this create a lot of problems. Any solution? HansVogelaar
If you paste a single value, click in the target cell, press F2, then press Ctrl+V followed by Enter or Tab.
Does that work?
- Thank you
