Question

4

Changing decimal separator in existing columns in LibreOffice Calc

rated 0 times [ 4] [ 0] / answers: 1 / hits: 9399 / 1 Year ago, sun, december 4, 2022, 11:16:46

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.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

diket

Add To Favorites

Follow

Total Points: 167

Total Questions: 124

Total Answers: 109

Location: Somalia

Member since Wed, Mar 15, 2023

1 Year ago

answered 1 Year ago corsee · Accepted Answer

Go to the Edit, and select Find & Replace.

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