Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

click to hide/show revision 2
retagged

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

click to hide/show revision 3
improve formatting

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

click to hide/show revision 4
retagged

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

click to hide/show revision 5
retagged

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

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