Data Format-Scientific Notation

Uploaded time: March 7, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

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.