erAck · HackerTrans

2 ปีที่แล้วdiscuss

> The link is just about a move from one part of Munich to another (MS German HQ has always been in Munich).

Nope. They moved from Unterschleißheim (administrative district of Munich in Upper Bavaria) to Schwabing (district of Munich town), which tax-paying wise makes the difference.

erAck

6 ปีที่แล้วdiscuss

And actually it depends on the locale you work in whether SEPT is a valid month abbreviation or not.

erAck

6 ปีที่แล้วdiscuss

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

6 ปีที่แล้วdiscuss

> if they had a "scientific mode" to not be smart with your data

That "scientific mode" is called text. Assign the column type Text during CSV import and nothing is converted to numeric or date.

erAck

6 ปีที่แล้วdiscuss

LibreOffice Calc: "SEPT-2" is a date, "SEPT2" is not.

comments