How to paste USA numerical values, like “1,940” without the trailing “0” being cut off in LibreOffice Calc
Solution 1:
In this case, set the default cell locale to “English (USA)” via “Tools > Options > Languages > Locale setting:”
Then the values paste correctly:
Solution 2:
Select the cells, then:
- Set the Number format to Number
- Set the decimal places to 0
- Check Thousands separator
