1. Click the [Replace] tool in the start menu bar;
2. Enter E in the search content input box , enter [X10] in the [Replace with] input box;
3. Click the [Replace All] button.
You can see that E has all turned into 10 at this time.
If we want to completely convert the format, please perform the following steps:
Click for more
Check the box to use wildcards and enter [-???]
Position the cursor in the [Replace with] option box and select the format
Check [Superscript]
Click [Replace All]
Same method , enter -?? in the search content, [replace with] the content is ^&, click Replace All
enter -? in the search content, replace with the content Yes ^&, click Replace All
At this time we can see that the scientific notation format has been successfully converted.
Recommended tutorial:excel tutorial
The above is the detailed content of How to convert scientific notation e into 10 in excel format. For more information, please follow other related articles on the PHP Chinese website!