Revision history [back]

How can I import German-formatted numbers as numbers

I have a CSV file which I want to import. I use US-English as my system locale and also as LibreOffice locale. However, the CSV file in question is formatted using German date&number formatting (e.g. 28.01.2013 and 1.568,38). I can import the dates fine when I set the column format to DMY, but I cannot seem to make LO recognize the numbers as numbers. I have already set the import language to "German (Germany)", but it doesn't seem to have any effect

LibreOffice 3.6.0.2/Ubuntu 12.04 LTS

 2 retagged Alex Kemp 10514 ●14 ●42 ●42 http://etmg.altervista...

How can I import German-formatted numbers as numbers

I have a CSV file which I want to import. I use US-English as my system locale and also as LibreOffice locale. However, the CSV file in question is formatted using German date&number formatting (e.g. 28.01.2013 and 1.568,38). I can import the dates fine when I set the column format to DMY, but I cannot seem to make LO recognize the numbers as numbers. I have already set the import language to "German (Germany)", but it doesn't seem to have any effect

LibreOffice 3.6.0.2/Ubuntu 12.04 LTS