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


Data Format-Scientific Notation

Uploaded time: March 7, 2022 Difficulty Beginner

Data Format-Scientific Notation

Data Format-Scientific Notation

In WPS Spreadsheet, scientific notation is normally applied to data so as to compute more digits yet save more spaces. Today we will introduce how to apply scientific notation format to data in cells.

You can use the following methods:

When entering large numbers, we can manually adjust the column width of the cells . By doing so, the number will display in scientific notation format automatically. In scientific notation, the power of 10 is generally expressed by E. For example, the number 100,000,000 will be displayed as 1E+09.

If you want to keep the cell column width unchanged, select the data area, and then go to the Home tab, where you can click the shortcut menu and find Scientific.


Of course, if you want to change the decimal places, right-click the cell area and select Format Cells, and its shortcut key is Ctrl+1.

You can find Scientific in the Category list, and then you can change the decimal places at Decimal Places on the right. We can preview the numerical changes in real time in theSample box above.

After setting, click OK.

Another feature of the scientific notation is that when the number exceeds 15 digits, the following number will automatically become 0.

Take cell E3 as an example. Now we need to enter the 18-digit order number. After entering, we can see that the 16th-18th digits are automatically changed to 0, which can't return to the normal format even if it's converted into the ordinary numerical format.In order to ensure accuracy, we'd better set some particularly long number strings into the text format in advance.

This is all about scientific notation in WPS Spreadsheet. Did you get it?

WPS Office Spreadsheet is helpful for various fields of studies: mathematics, statistics, data science, engineering, finance, and such. Rich in functions paired with teaching procedures, WPS Office Spreadsheet definitely is a professional and reliable toolkit.

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