How to Change Comma to Period in WPS Office

This updated guide explains how to change comma to period in WPS office with clear steps, practical tips, and useful context. When working with decimals in WPS Office Sheets, displaying commas instead of periods can cause difficulties in calculations or data formatting. If you are looking for a way to convert commas to periods, these article will guide you through the process quickly and accurately.

to change the comma to the dot of a decimal number in WPS Office, you can do one of these:

1. Changes in WPS Office Sheets App

Setting in Options is a quick way to change commas to periods in WPS Office. You do as follows:

Step 1 : Open the WPS Office Sheets application, select Blank to open a new document.

Step 2 : On this new document interface, select Menu → Options .

Step 3: Options appears, select General and Save , uncheck Set decimal symbol to , (set decimal symbol to,). Then select OK .

A message appears, select OK .

So you have done how to change commas to periods in WPS Office. You just need to exit the Sheets program and relaunch WPS Office to apply the changes.

2. Changes in Windows Control Panel

Customizing the settings in Control Panel is a way to change commas to periods in WPS Office. You do these steps:

Step 1 : Open the Start menu, type the keyword Control Panel and select Control Panel in the search results.

Step 2: In the Control Panel window, select View by as Category , then select Clock and Region .

Step 3 : Select Region .

Step 4: The Region dialog box appears, select Additional settings .

Step 5 : In Decimal symbol , delete the comma and enter a period and select OK .

So you have done how to change commas to periods in WPS Office by setting up in the computer's Control Panel.

Above, TipsMake.com has shared with you 2 ways to change commas to dots in WPS Office Sheets. So, to change commas to dots of decimal numbers in WPS Office, you just need to perform one of the 2 setup methods that the article has shared and you have quickly changed commas to dots in WPS Office. Hope this article is useful to you!