How to Change a number to Scientific Format

Scientific Formatting is the way that making you easily handle very large numbers or very small numbers. Please follow the steps below:

Step 1: Select the data range;

Step 2: Right click to bring up the dialog box, from the list click "Format Cells";

Step 3: In the "Format Cells" window, click "Scientific" from the left navigation;

Step 4: Click "OK" at the bottom.

Please check here if you want to convert into to x10 scientific format.