# Excel: How to Convert Scientific Notation to Text

Whenever you type a number into Excel that contains more than 11 digits, Excel will automatically format the number using scientific notation with E+11 displayed at the end of the number.

The easiest way to convert scientific notation to text is to use the TEXT function with the following formula:

`=TEXT(A1, "0")`

This particular formula will convert the number displayed with scientific notation in cell A1 to text.

The following example shows how to use this formula in practice.

## Example: How to Convert Scientific Notation to Text in Excel

Suppose we type 123456789111 into Excel: Excel formats the number using scientific notation as 1.23457E+11 since this number contains 12 digits.

To convert this number from scientific notation to text, we can type the following formula into cell B1:

```=TEXT(A1, "0")
```

The following screenshot shows how to use this formula in practice: This formula uses the TEXT function with the argument “0” to format the number in cell A1 in such a way that all digits are displayed.

We have now successfully converted the number in scientific notation in cell A1 into text in cell B1.

Note: You can find the complete documentation for the TEXT function in Excel here.