WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to store number as text in Excel

August 1, 2022
8.9K Views

Undoubtedly ,Excel is one of the most widely used spreadsheet software. It's easy to use and has many features that make it an ideal application for business data analysis and presentation. However, sometimes you may need to store numbers as text in Excel. This is especially true when you work with currency values, percentages, and other non-integer numbers.

Storing numbers as text can be useful when you need to manipulate your data with formulas or use it in a chart or graph. Here is how you can store a number as text in excel. This method is simple and quick and will ensure that you don't lose important data as a result of using the wrong type. Follow the steps below to learn how to properly store numbers:

Tips that are provided in this article are compatible with versions 2010/2013/2016.

How To Store Number as Text in Excel using the TEXT function?

Excel has a great built-in function to convert numbers to text; this is the TEXT function.

The TEXT function converts a number into a text string

To convert a number into text:

1.Select the cell you want to use as input for your calculation. The formula will be entered in this cell by default.

=TEXT(Cell n, “0”)

2.Let’ s suppose we want to convert entries in A1 in text

3.We will use it as

=TEXT(A1, “00”)

The number of zeros depends upon the value of the digit As you can see from above, the number is stored as text.

How To Store Number as Text in Excel using format method?

The format method is a function that allows you to change the number format of a cell. It does not change the value of the cell, but only modifies its appearance. The format method can be used to store numbers as text in excel.

To store numbers as text in excel:

1 .Click on the cell where you want to store number as text.

2. Left click on the cell

3. Select format

4. Select format as text option and click ok.

That’s how to store number as text in Excel.

How To Store Number as Text in Excel using text to column wizard?

1.The Text to Column wizard is a great tool to use when you have data in a table that you want to convert into text.

2.Navigate to Text to Column wizard and move to step 3

3.Make sure to check the text in this wizard.

4.Now you will see that your number has been converted to text.

That’s how to store number as Text in Excel using the text to column wizard.

Did you learn about How to store number as Text in Excel?. You can follow WPS academy to learn more features of Word documents, Excel Spreadsheets, and PowerPoint slides.

You can also download WPS Office to edit word documents, Excel Spreadsheets, and PowerPoint free of cost. Download Now! And get an enjoyable working space.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.