Ask Your Question

How to replace all commas with dots in libreoffice calc but only in certain cells [closed]

asked 2014-07-17 08:39:44 +0100

robert.weijerman1 gravatar image

I live in the netherlands therefore I use the comma to indicate half or quarter etcetera. I imported a lot of tables having numbers that use the comma the other way. I want to change all the commas in those cells into dots. Thank you so much for your help in advance:) Robert

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 2016-02-29 21:52:18.450450

2 Answers

Sort by » oldest newest most voted

answered 2014-07-17 11:25:00 +0100

blindape gravatar image

Hi Robert,

Depending on how you import those tables and your Locale settings those changes should be handled automatically.

However if the commas aren't converted and you need to import those tables on a regular basis then I would recommend using a formula to do the job.

=SUBSTITUTE(A1;",";"") will remove the commas from the number in A1. Another issue that may occur is that the number 1000 represented as 1,000 will become 1 after import as the comma is now acting as a decimal point. If this occurs you will need to multiply values by 1000. Without seeing an example of the tables it is difficult to visualise the best approach.



edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-07-17 08:39:44 +0100

Seen: 7,859 times

Last updated: Jul 17 '14