General format and special format

Uploaded time: August 27, 2021 Difficulty Intermediate

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

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?