From Free Knowledge Base- The DUCK Project: information for everyone
114 bytes added,
19:02, 18 January 2018 The following lines were added (+) and removed (-):
When using Excel, a partial date entry such as MM-DD ie: 1-25 will automatically result in conversion to the configured format, for example MM/DD/YYYY or 1/25/2018. This does not occur by default in Calc. When using Excel, a partial date entry such as MM-DD ie: 1-25 will automatically result in conversion to the configured format, for example MM/DD/YYYY or 1/25/2018. This does not occur by default in Calc. Although the ISO 8601 date format of YYYY-MM-DD is the most logical, it is not what Americans are accustomed to.