In LibreOffice Calc, if I have a column with a lot of numbers in this format 8,1 (comma), how can I transfer all these numbers to the format 8.1 (dot)?

When I say "a lot" I mean thousands of numbers, so it is just impossible to rewrite it again in the right format.


Go to the Edit, and select Find & Replace.

Under Search for, put ,- and under Replace with, put .. Then press Replace All


--For ubuntu system: Go to System Setting -> Language Support - Regional Format -> "Display numbers, date and currency amounts in the used format for:" and choose your local system.

Language Support Settings

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.