Imported text is converted to date



I have a problem importing a text string.  In the attached .csv file the string "10.4.2" is imported 
incorrectly as a date, and once imported, there does not seem to be a way to recover the correct text.  (I 
just open the file, and it is imported automatically.)  LibreOffice and Excel for Windows import it as text, 
as intended.  The only workaround I have found is to prefix it with an apostrophe ("'"), which has the 
disadvantage that an unwanted apostrophe appears in those spreadsheets.

Is there another way to import this as text--preferably automatically?  Is this a bug?

The problem occurs in versions 1.10.9 for Windows and 1.10.17 for Linux.  I have not tried 1.12 yet.

Attachment: test.csv
Description: Text Data



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]