WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


General format and special format

Uploaded time: August 27, 2021 Difficulty Intermediate

General format and special format

General format and special format

When we use WPS Spreadsheet to enter data, we often need to convert between the general and the special format. So let's take a look at what is the general format of cells, what is the difference between them, and how we can convert them.

Take this table as an example. The cell contents in the first row of this table are all in the General format. The General format means that the contents of the cells are simply expressed in numerical form. The second row of the table is in a special format. Commonly used special formats include Percentage, Currency, Date and Time, etc. 


The special formats don't simply express in numerical values. For instance, the Percentage format will add a percent sign after the value, and the Currency format will add a currency symbol before the value. This is the difference between the regular format and the special format.

So how can we convert the special format to the regular format in our work?

1. Select all the cells in the second row.

2. Click the Home tab, and find the function area for setting the cells.

3. Click the gray inverted triangle arrow; then you can see the commonly used special cell formats in the pop-up menu.

4. Now select the General option.

Easy your work with WPS Spreadsheet like Microsoft Excel. Did you get it?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.