EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Convert Numbers to Text in Excel
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (36+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Convert Numbers to Text in Excel

By Madhuri ThakurMadhuri Thakur

Converting Numbers to Text in Excel

Convert Numbers to Text in Excel (Table of Contents)

  • Steps to Convert Numbers to Text in Excel
  • Examples to Convert Numbers to Text in Excel

How to Convert Numbers to Text in Excel

There are different ways to convert numbers to text in excel. In Excel, we have the TEXT function, which is used to convert numbers to text named. Text function is one of the ways to convert numbers to text. For this, we just have to select the numbers we want to convert into text and select the format we want to change that number to text. Selecting Zero will keep that number but into text, and if we change that format, the value will be changed in that format but will be in the text.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Steps to Convert Numbers to Text in Excel

Below mentioned is the easiest way to Convert Numbers to Text in Excel. If you have only two or three cell data that needs to be converted into text, these are the simple steps you can follow.

Step 1 – By double-clicking, select the cell which you want to change the data and enter an apostrophe before the number that is entered in the cell.

Step 2 – Press enter key, which will move the selection into the below cell and the data, which is a number being changed into text format.

Converting Numbers to Text in Excel 1-1

  • Once done with the above steps, you can confirm whether the number has been changed to the text format or not.

Step 3 – Select the cell which already changed into the text; while selecting the cell, a message box icon with a drop-down appears on the left side.

  • Once you point on the message box icon, the corresponding text will be displayed, which shows if the number in the cell is converted into text?

Converting Numbers to Text in Excel 1-2

  • If you click on the dropdown arrow, it will show the given text is already in text format. Or the number is stored in text format.

Converting Numbers to Text in Excel 1-3

Step 4 – By selecting the dropdown arrow, it is possible to change the text to its old form using Convert to Number.

Converting Numbers to Text in Excel 1-4

Examples to Convert Numbers to Text in Excel

You can download this Convert Numbers to Text in Excel Template here – Convert Numbers to Text in Excel Template

These are the following examples to convert numbers to text:

1. Using General Formula

2. Using format cells command

3. Using addon tools

Example #1

As a simple method, you can use this inbuilt function Text which is shown in the below screenshot, and the format is as follows.

=Text(value, format_text)

Example 2-1

  • Value refers to the cell that contains the data you want to convert, and the next part format_text represents in which format you want to see the data.

Example #2

  • In cell C2 please enter the formula =Text (B2, “0”).

Example 2-2

  • Then press Enter key.

Converting Numbers to Text in Excel 2-3

  • Drag and fill up to the range that you want to apply. The results as shown below.

Converting Numbers to Text in Excel 2-4

  • After applying the formula, the values are pasted in the same sheet. The numbers are changed into text format. The green indication in the upper corner of the cell commonly shows when you have entered a text formatted value into the cell. Or when you change the format of any given data to the text format.

Converting Numbers to Text in Excel 2-5

Converting Numbers to Text in Excel 2-6

Example #3

  • To change the format of the result, we can change the formula as =Text(B1, ”000000”), which will result in the whole data will be shown in six-digit numbers. The missing place values will be filled with “0”. If you want to change the whole data into a unique format or a unique number of decimals, then this format is preferred.
  • In the above example, column Data1 consists of integer numbers with different decimal places. So here we want to make it in a unique way. To change the given numbers into a similar number of decimal values, we have applied the formula. The format has given 6 decimal places =Text(B1, ”000000”). So the numbers are changed to 6 digit numbers, and the missing decimal places are filled with zero.

Example 2-7

Example #4

To convert numbers to Text in Excel with different decimal points, the changes to do with the formula is

=Text(B1,”00.000’). Which will keep the given data into a similar format in such a way number of digits after the decimal point? The figure is given shows the result after applying the formula in the given data.

In this example, we want to make the number of digits after the decimal point into a unique number. So the formula is changed into =Text(B1, ”00.000’. This will show 3 digits after the decimal point.

Using Format Cells Command

Convert Numbers to Text in Excel using Format cells command is also recommended. By right-clicking the selected cell, it will get an option Format Cells. This will lead to another window that offers all data that we are using as a number, date, general, etc.

using Format cells 2-8

  • According to your recommendation, theFormat_Cells Command is commonly used to change the data of the given cells into another format.

Converting Numbers to Text in Excel 2-9

Automatically set the data type of empty cells.

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.

How to Set the Data Type Automatically in Excel?

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.

Converting Numbers to Text in Excel 3--1

How to Avoid Missing Numbers while Converting Numbers into Text?

It is better to keep the numbers in text format to prevent missing numbers while processing or changing from one sheet to another.

Converting Numbers to Text in Excel 3-2

  • In the above, once you press enter after entering the numbers, the common result will be as below.

Converting Numbers to Text in Excel 3-3

  • The initial “0” will be lost since you haven’t set any data type to this column. The same will happen when you try to copy-paste the same numbers from this sheet to another.

Using Add-On Tools

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.

Step to Download Kutools

  • Go to Google and search for free Kutools and download the setup of Kutools from there.

Download Kutools 3-4

  • This provides different options to process your data in any way you want.
  • More than the available functions with normal excel here, you can find customized options to deal with functions.

Converting Numbers to Text in Excel 3-5

  • Which shows two different options as Text to numbers and Numbers to Text.
  • By clicking the Numbers to Text option, you can change the selected numbers to text.

Using Excel Macros

  • Excel macros are another option where you can design your own customized functions to change the numbers into text.
  • If you are good at VBA, then go for this method where you can design functions and apply that to the data where ever you want.
  • It is possible to create VBA functions like stored procedures /functions. So as like the normal functions can directly apply this to the excel cells.
  • Another option is to create separate macro fixing buttons and assign created functions to the macro that you have created.

Things to Remember About Convert Numbers to Text in Excel

  • If the number starts with “0”, be aware of changing the data into text before processing it further. There are chances to lose this initial zero while doing copy paste into another cell.
  • If you know the data type prior to processing, it sets the empty cell format before you process it.
  • If you want to keep the numbers as text and found any issues on copy-pasting it into another sheet, keep the data in a note pad and again copy it from the notepad
  • Select the better option according to the quantity of data you need to process.

Recommended Articles

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 –

  1. Text Formula In Excel
  2. Formatting Text in Excel
  3. Count Cells with Text in Excel
  4. VBA Text
Popular Course in this category
MS Excel Training Bundle
  13 Online Courses |  100+ Hours |  Verifiable Certificates |  Lifetime Validity
4.5
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Training (23 Courses, 9+ Projects)4.8
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download Convert Numbers to Text in Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Convert Numbers to Text in Excel Template

EDUCBA

डाउनलोड Convert Numbers to Text in Excel Template

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. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more