How to convert scientific notation e into 10 in excel format

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!