# How to remove thousand separator when copy/paste in LibreOffice? [closed]

Hi,

using LibreOffice Calc 3.6.5.2 on Windows XP.

- Open Notepad and type in number: 1.000
- Mark whole number and copy it.
- Paste the content into Calc cell A1. Number is copied successfully. Target number in Calc becomes number.
- 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 Thanks