Excel Store Number as Text

In this tutorial, we will learn about How to Store Numbers as Text in Excel

Example:

There are numbers written as 000876 inside a cell, and I want to store these numbers as text in Excel.

So to store this number as Text in excel, there are 2 methods:

1. Applying a Single Quote

2. Applying Format Cells option

1. Applying a Single Quote

1. Put a Single Quote before the numbers 000876 like this ‘00876

2. Press Enter

3. Excel will store the numbers as text

2. Applying Format Cells option

Before writing the number you have to format the cell by following the steps given below:

1. Select the cell

2. Right-click on it and select Format Cells option

3. A Format Cells Panel will open,

4. Click on Text option under Category to convert numbers into text

5. Click OK

6. Write the numbers in the cell and Excel will store the number as Text







Download 101 Ultimate Excel Formulas Guide