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
