How to change cell formats

November 5, 2021
537 Views 0

1. Select the cell range.

2. Right-click on it and choose Format Cells... (Shortcut keys: Ctrl+1)

How to set cell format (1).gif 


3. Then we can change the cell format in the Format cells pop-up window.

How to set cell format (2).gif 

In this example, we choose the Currency tab and set '2' Decimal places for the data.


WPS Spreadsheet could be an alternative to Microsoft Office Excel, including more than 100 built-in formulas, pivot tables, and more. Includes advanced animation, slide transitions, and supports for video, images, audio, and even flash.

Was this helpful?