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) ?
Use a cell style with English format settings, which will have a decimal point instead of comma (Format settings Numbers> Language)
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.)
Asked: 2017-10-14 20:28:48 +0100
Seen: 23,376 times
Last updated: Oct 14 '17
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
By the way: Can't you set the CAD program to accept decimal numbers with the comma as the decimal separator?