Ask Your Question

How can I import German-formatted numbers as numbers [closed]

asked 2013-03-01 10:25:36 +0200

Stefan Seidel gravatar image

updated 2015-10-25 05:40:37 +0200

Alex Kemp gravatar image

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 12.04 LTS

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-25 05:41:07.330662


I've since upgraded to 4.0.1 and the solution below works now.

Stefan Seidel gravatar imageStefan Seidel ( 2013-03-12 08:50:16 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-03-01 11:59:56 +0200

JohnSUN gravatar image

import German-formatted numbers as numbers

edit flag offensive delete link more

Question Tools


Asked: 2013-03-01 10:25:36 +0200

Seen: 476 times

Last updated: Mar 01 '13