# Revision history [back]

### How to remove thousand separator when copy/paste 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 Thanks

 2 retagged qubit 9538 ●19 ●94 ●65

### How to remove thousand separator when copy/paste 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 Thanks

 3 improve formatting qubit 9538 ●19 ●94 ●65

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

Hi, Hi,

using LibreOffice Calc 3.6.5.2 on Windows XP. 1. XP.

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

 4 retagged qubit 9538 ●19 ●94 ●65

### How to remove thousand separator when copy/paste 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 Thanks

 5 retagged qubit 9538 ●19 ●94 ●65

### How to remove thousand separator when copy/paste 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 Thanks

 6 retagged Alex Kemp 10514 ●14 ●42 ●42 http://etmg.altervista...

### How to remove thousand separator when copy/paste 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 Thanks