4 ms·

LibreOffice AND Google Docs fall in the same exact spot than Excel here. Try it. Type "SEPT-2" or "SEPT2" in any of them and see what happens.

• erAck 6y ago
  LibreOffice Calc: "SEPT-2" is a date, "SEPT2" is not.
  • mcv 6y ago
    Do they change the data or only the representation? Several people here argued that LibreOffice preserved the original data, which would be a pretty fundamental difference in this context.
    • erAck 6y ago
      SEPT-2 is changed to date (that is how all major spreadsheet software works if an input is accepted as date), SEPT2 is kept as text as entered.
      • erAck 6y ago
        And actually it depends on the locale you work in whether SEPT is a valid month abbreviation or not.
  • wesleywt 6y ago
    Some biologist will write a gene as Sept-2. Its best to change the name so that its not a date.