Forum Discussion
Date format
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.
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.
