using LibreOffice Calc 188.8.131.52 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:
See attached file for sample.numbers.ods