3 ms·
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.
by 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 agoAnd actually it depends on the locale you work in whether SEPT is a valid month abbreviation or not.