Ask Your Question

comma to dot [closed]

asked 2017-10-14 20:28:48 +0100

aspitieris gravatar image

Hi im using LibreOffice in Greece. I have a problem that I dont know how on Calc : I have numbers like 123456,09 and I want to insert them into a cad program. How I can change that coma to a dot. (123456.09 correct form to insert to CAD) ?

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 2020-10-17 18:25:24.471351


By the way: Can't you set the CAD program to accept decimal numbers with the comma as the decimal separator?

Lupp gravatar imageLupp ( 2017-10-14 20:53:45 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-10-14 20:44:41 +0100

komma4 gravatar image

Use a cell style with English format settings, which will have a decimal point instead of comma (Format settings Numbers> Language)

edit flag offensive delete link more

answered 2017-10-14 20:50:35 +0100

Lupp gravatar image

updated 2017-10-14 20:56:04 +0100

You needn't change that. LibO Calc will do it for you.

-1- Select the range containing the numeric results or contents you want to copy and to paste to a different application.
-2- > 'Format' > 'Cells' > tab 'Numbers'
-3- There you can use a dropdown list under 'Language' to select a language. Choose 'English (UK)' e.g.

The language (in fact a "locale") is associated with rules concerning the display of numeric values. For English locales this will include the usage of the point as the decimal separator.

(Sorry. Posts crossed. A named cell style is clearly preferrable over direct formatting.)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-10-14 20:28:48 +0100

Seen: 23,376 times

Last updated: Oct 14 '17