Number to text converter in excel

Just double-click in a cell and enter the apostrophe before the numeric value. You will see a small triangle added in the corner of this cell. This is not the best way to convert numbers to text in bulk, but it's the fastest one if you need to change just 2 or 3 cells.

You may be surprised but the Excel Text to Columns option is quite good at converting numbers to text. Just follow the steps below to see how it works. I hope the tips and tricks from this article will help you in your work with numeric values in Excel. Convert number to string using the Excel TEXT function to adjust the way your numbers will be displayed, or use Format Cells and Text to Columns for quick conversions in bulk.

If these are just several cells, add an apostrophe. Feel free to leave your comments if you have anything to add or ask. Be happy and excel in Excel! Search by part not by the entire number. For example, you may need to find all numbers that contain 50, like in , , , etc. However, if these cells are formatted differently, Excel will not see identical values as matching. Select T ext and click the F inish button. Therefore, if you concatenate an empty text string and a number, this returns a text string containing just the number.

As required, the values in column B of the results spreadsheet are text representations of the numbers in column A. Excel provides the following three functions that are designed to convert numbers into text values:. The Excel Text Function converts a supplied number to text, using a user-specified format.

The syntax of the function is:. The spreadsheet below shows examples of the Excel Text Function used to convert a simple number, a currency, a date and a time into text:. The Excel Text Function, and the available formatting options, are described in further detail on the Excel Text Function page. The Excel Dollar Function rounds a number to a specified number of decimal places and converts the rounded number to text, using a currency format.

It is possible to Automatically set the data type of empty cells and set the format of a range of cells in advance before entering the data into the cells. The same method is preferred in this case. Below is the screenshot where the format of the empty cells is changed into text.

So if you enter the numbers into these cells, the data will keep the format as text automatically. It is better to keep the numbers in text format to prevent missing numbers while processing or changing from one sheet to another. Different Add-on Tools like Kutools for Excel. These are built-in tools for excel which can be downloaded and used as add-on functions with your excel. This has been a guide to Convert Numbers to Text in Excel. Here we discuss how to use Convert Numbers to Text in Excel along with practical examples and a downloadable excel template.

You can also go through our other suggested articles —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.