Change Number Formatting with Decimal Places and Thousands Separators

Spreadsheets English version supports decimal places and number separator setting. When you finish setting the requirements and restart the software, Spreadsheets will display the number in the form that you’ve set. Since some countries use different characters for the thousands separator and the decimal point, we compared the thousands separator in German and American English.

Example: Compare German and American thousands separators.

Enter 123123123 in a cell. Go to Home tab> Comma Style. The American thousand separators style is showed in Figure A while the German way is in Figure B & C. The manual setting of the decimal symbol will take effect after you quit and restart Kingsoft Spreadsheets.

Figure A

 

American thousands separators

Figure B

Set decimal symbol to ","

Figure C

German thousands separators

For the setting of decimal places, you just need to click on the "Increase/decrease decimal" tab in the middle of Home Menu.