Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 06 Feb 2013 09:08:19 +0100How to remove thousand separator when copy/paste in LibreOffice?https://ask.libreoffice.org/en/question/11480/how-to-remove-thousand-separator-when-copypaste-in-libreoffice/Hi,
using LibreOffice Calc 3.6.5.2 on Windows XP.
1. Open Notepad and type in number: 1.000
2. Mark whole number and copy it.
3. Paste the content into Calc cell A1. Number is copied successfully. Target number in Calc becomes number.
4. Repeat steps from 1 to 3 by instead in step one type in number: 1.000.000 and in step 2 paste into cell A2.
Number in A2 cell is pasted with dots! (thousand and million separators) and so becoming a text in Calc instead of number. To make me possible to execute some calculations in Calc like e.g. formula in B1=A1+1 I need to manually remove dots from cell A1.
How to make it possible to recognize thousand, millions etc separator as separator and paste it as number?
P.S. I am using Slovenian language settings where dot "." is thousand separator and comma "," is decimal separator. So million (with two decimal points) is written as: `1.000.000,00`
See attached file for sample.[numbers.ods](/upfiles/13601380847454316.ods)
ThanksfrozWed, 06 Feb 2013 09:08:19 +0100https://ask.libreoffice.org/en/question/11480/