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.