Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or

How to change or convert number to text in Excel?

Sometimes you may not want the numbers in the cells getting involved in calculating, or you may want to display leading zeros in numbers in cells. For doing so, you may need to change a number into text. The following methods can convert numbers in cells to text in Excel.

Convert number to text with Text function

Convert number to text with Format Cells command

Convert number to text with Kutools for Excel


Convert number to text with Text function

If you are familiar with Microsoft Excel's formulas, you can convert numbers in cells to text with Text function.

If you just only want to convert the number to text without any formatting, you can use the formula: =TEXT(A1,"0");

1. In cell E1, please enter the formula =TEXT(A1,"0").

doc convert number to text 1

2. Then press Enter key. And select the cell E1, drag the fill handle over the range of cells that you want to apply this formula.See screenshot:

doc convert number to text 2

Note: As the data is formula, you can change the formulas to values. Copy the cells and right-click where you want to paste the values and select Paste special > Values.

If you want to display the leading zero in numbers, you can use this formula: =TEXT(A1,"00000"); such as convert 23 to 00023.

As the above steps, if you apply this formula, you will get the following result:

doc convert number to text 3

And if you want to convert the numbers to text which keep several decimal digits, you can use this formula: =TEXT(A1,"0.000"). Such as convert 23 to 23.000.

Also with above steps, if you apply this formula, you will get the result as the following screenshots:

doc convert number to text 4

Note: you can define the text style. For example, if you want to convert the numbers to text with a telephone number format, you can replace the "000" with "00-00000", or others.


Convert or spell out numbers to English or Chinese currency:

With Kutools for Excel's Numbers to Words feature, you can spell out numbers into English and Chinese words in Excel.For example, it can spell out the "12.75" to "Twelve dollars and seventy-five cents".

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!


Convert number to text with Format Cells command

Microsoft Excel's Format Cells command is also able to convert numbers to text.

1. Select the numbers that you want to convert to text.

2. Right click the selected range, and choose the Format Cells item from context menu. See screenshot:

doc convert number to text 5

3. In the Format Cells dialog box, select the Text item in the Category box under Number tab, and then click the OK button. See screenshot:

doc convert number to text 6

4. Then numbers in selected range are converted into text.


Convert number to text with Kutools for Excel

If you have Kutools for Excel installed, it will be easier for you to convert numbers in cells to text with Convert between Text and Number.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. 

After installing Kutools for Excel, please do as below:

1. Select the range with numbers that you want to change to text.

2. Click Kutools > Content > Convert between Text and Number. See screenshot:

3. In the Convert between Text and Number dialog box, check the Number to text option, and then click the OK or Apply button. And all numbers have been converted to text in the original range. See screenshot:

doc convert number to text 8

Click to Download Kutools for Excel and free trial Now!


Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

Related article:

How to change or convert text to number in Excel?


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Alex · 1 months ago
    Muy buen artículo gracias, también hay una APP Android para usar en celulares y tabletas, que convierte números a palabras, ideal para escribir rápidamente y en donde quiera que estemos, números en formato de letras ya sea para: cheques, contratos o en documentos importantes, esta APP esta disponible en:

    https://play.google.com/store/apps/details?id=net.sabro.numerosaletras
  • To post as a guest, your comment is unpublished.
    Patrick · 3 months ago
    @Excel Expert Please send the sample.

    123oldmonks1@gmail.com

  • To post as a guest, your comment is unpublished.
    Glenys Pollock · 8 months ago
    how do I maintain -1 as a superscript when I make a graph from an excel spreadsheet

  • To post as a guest, your comment is unpublished.
    rockymondal7063@gmail.com · 1 years ago
    @kamlesh manchekar Add this with below formulas in one



    &CHOOSE(MID(TEXT(B3,"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety")
    &IF(--MID(TEXT(B3,"000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(B3,"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(B3,"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen"))
    &IF((--MID(TEXT(B3,"000000000.00"),4,1)+MID(TEXT(B3,"000000000.00"),5,1)+MID(TEXT(B3,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(B3,"000000000.00"),7,1)+MID(TEXT(B3,"000000000.00"),8,1)+MID(TEXT(B3,"000000000.00"),9,1))=0,--MID(TEXT(B3,"000000000.00"),7,1)<>0)," Thousand "," Thousand and "))
    &CHOOSE(MID(TEXT(B3,"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")
    &IF(--MID(TEXT(B3,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(B3,"000000000.00"),8,1)=0,--MID(TEXT(B3,"000000000.00"),9,1)=0)," Hundred "," Hundred and "))&
    CHOOSE(MID(TEXT(B3,"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
    &IF(--MID(TEXT(B3,"000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(B3,"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(B3,"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))

    &" Euro & "&RIGHT(TEXT(B3,"000000000.00"),2)&"/100"
  • To post as a guest, your comment is unpublished.
    rockymondal7063@gmail.com · 1 years ago
    @kamlesh manchekar =CHOOSE(LEFT(TEXT(B3,"000000000.00"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")
    &IF(--LEFT(TEXT(B3,"000000000.00"))=0,,IF(AND(--MID(TEXT(B3,"000000000.00"),2,1)=0,--MID(TEXT(B3,"000000000.00"),3,1)=0)," Hundred"," Hundred and "))
    &CHOOSE(MID(TEXT(B3,"000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
    &IF(--MID(TEXT(B3,"000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(B3,"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),
    CHOOSE(MID(TEXT(B3,"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))
    &IF((--LEFT(TEXT(B3,"000000000.00"))+MID(TEXT(B3,"000000000.00"),2,1)+MID(TEXT(B3,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(B3,"000000000.00"),4,1)+MID(TEXT(B3,"000000000.00"),5,1)+MID(TEXT(B3,"000000000.00"),6,1)+MID(TEXT(B3,"000000000.00"),7,1))=0,(--MID(TEXT(B3,"000000000.00"),8,1)+RIGHT(TEXT(B3,"000000000.00")))>0)," Million and "," Million "))
    &CHOOSE(MID(TEXT(B3,"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")
    &IF(--MID(TEXT(B3,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(B3,"000000000.00"),5,1)=0,--MID(TEXT(B3,"000000000.00"),6,1)=0)," Hundred"," Hundred and"))
  • To post as a guest, your comment is unpublished.
    Ravi Shankar S · 1 years ago
    @Sparky This is for All! Any body wishing to get your numbers to text (like in words) I have already created a VB some 12 years ago which used to work perfectly as I was doing some Financial projects that period of time....
    Any body interested to transform the code to your excel can send me a mail on R-aviang@live.com. I will share the code. Thanks
    Ravi Shankar S
  • To post as a guest, your comment is unpublished.
    Avinash AVachar · 1 years ago
    @Excel Expert send me excel convertor file on aavachar@gmail.com
  • To post as a guest, your comment is unpublished.
    eduarlevy@gmail.com · 1 years ago
    I would like to convert the date 201901 in word " january¨ or number 01 (means january in numbers) in excel sheet. Thank you
  • To post as a guest, your comment is unpublished.
    Alice · 2 years ago
    How do you convert to text an amount with decimal number of which the decimal numbers remain as numbers? example: 750.25 - SEVEN HUNDRED FIFTY & 25/100.. Thank you
  • To post as a guest, your comment is unpublished.
    Anton Thelander · 2 years ago
    Large thanks!
  • To post as a guest, your comment is unpublished.
    Tere Martin Rangel · 2 years ago
    Cuando convierto un numero en texto me lo pone en Ingles y en Dólares, lo necesito es en Español y en pesos Mexicanos, ¿como puedo resolver esto?
    De antemano gracias por la atención que se sirva darme.
  • To post as a guest, your comment is unpublished.
    mg · 2 years ago
    Hi, not working in our currency which is philippine peso. Kindly help. Thank you.
  • To post as a guest, your comment is unpublished.
    LJ · 2 years ago
    @Excel Expert Would appreciate a sample please :) Thanks!
  • To post as a guest, your comment is unpublished.
    Ata · 2 years ago
    @stephdegr@gmail.com It might be another Character that appears like the Space character. When you copy and paste data from external sources such as websites, unwanted characters will come across with different ASCII codes that may look like the Space character.

    The above formula meant to remove only the Space character from your string. Space character means the value of the Char(32) on the ASCII values.

    Best would be to modify the formula as =SUBSTITUTE(A1,CHAR(32),"")
  • To post as a guest, your comment is unpublished.
    Ata · 2 years ago
    @MNB A workaround can be using the SUBSTITUTE formula ten times to replace all the numbers with the respective letters:

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,"Q"),1,"W"),2,"R"),3,"E"),4,"Z"),5,"S"),6,"T"),7,"B"),8,"K"),9,"A")

    Where A1 is the reference cell for the numeric values.
  • To post as a guest, your comment is unpublished.
    stephdegr@gmail.com · 2 years ago
    @Ata Great tip thanks. Now FYI this didn't work at first for me, as for some reason it didn't recognize the space.. but when I cut and pasted the "space" from the source (cut-and-pasted financial values from a web page) instead of pressing the space bar it worked fine.
  • To post as a guest, your comment is unpublished.
    Praveen · 2 years ago
    After converting words to figures, How can start with "Rupees" and end with "Only"
  • To post as a guest, your comment is unpublished.
    Darshan · 2 years ago
    @vinayujjain@gmail.com Using this formula, 99 would convert into 'Nine Nine'. Same goes for every other number (two digited). Seems the question was to how to spell a numerical value.
  • To post as a guest, your comment is unpublished.
    MNB · 2 years ago
    If i have assign
    0 as Q
    1 as W
    2 as R
    3 as E
    4 as Z
    5 as S
    6 as T
    7 as B
    8 as K
    9 as A
    how to convert a numerical value to text code like 2356 i want 2 as R, 3 as E, 5 as S, 6 as T, so when i write 2356 i got result REST?
  • To post as a guest, your comment is unpublished.
    Anonymous · 2 years ago
    @vinayujjain@gmail.com Use replace function. Highlight the cells you want to edit then Ctrl+H. Replace space to blank
  • To post as a guest, your comment is unpublished.
    Ramesh · 2 years ago
    When I entered Numbers in Cell Eg : 150 the will written as One hundred and fifty
  • To post as a guest, your comment is unpublished.
    Ata · 2 years ago
    @sikhar.1791@gmail.com =SUBSTITUTE(A1," ","")
    Where A1 is reference cell for 1234 5678 1234
  • To post as a guest, your comment is unpublished.
    mary · 3 years ago
    how translate staff id to text as "filled" and vice versa for nil staff ID to 'vacant"
  • To post as a guest, your comment is unpublished.
    vinayujjain@gmail.com · 3 years ago
    @kamlesh manchekar Try Using This -

    =IF(MID(K14,1,1)="1","One",IF(MID(K14,1,1)="2","Two",IF(MID(K14,1,1)="3","Three",IF(MID(K14,1,1)="4","Four",IF(MID(K14,1,1)="5","Five",IF(MID(K14,1,1)="6","Six",IF(MID(K14,1,1)="7","Seven",IF(MID(K14,1,1)="8","Eight",IF(MID(K14,1,1)="9","Nine",IF(MID(K14,1,1)="0","Zero",""))))))))))&" "&IF(RIGHT(K14,1)="1","One",IF(RIGHT(K14,1)="2","Two",IF(RIGHT(K14,1)="3","Three",IF(RIGHT(K14,1)="4","Four",IF(RIGHT(K14,1)="5","Five",IF(RIGHT(K14,1)="6","Six",IF(RIGHT(K14,1)="7","Seven",IF(RIGHT(K14,1)="8","Eight",IF(RIGHT(K14,1)="9","Nine",IF(RIGHT(K14,1)="0","Zero",""))))))))))


    Instead of Using "One" "Two" "Three", You can change what ever you want against perticular No, also above code is for only upto two digits. you can extended it to any no by adding IF with MID formula.


    K14 is reference cell for Number.
  • To post as a guest, your comment is unpublished.
    vinayujjain@gmail.com · 3 years ago
    @sikhar.1791@gmail.com Try Using =CONCATENATE("",LEFT(H20,4),MID(H20,6,4),RIGHT(H20,4))


    Whereis H20 is reference cell for 1234 5678 1234
  • To post as a guest, your comment is unpublished.
    sikhar.1791@gmail.com · 3 years ago
    i m a novice. text in cells read as 1234 5678 1234 i.e with a space bet each 4 digit clusters. how can i compress it as 123456781234 ?
  • To post as a guest, your comment is unpublished.
    Mahmuda · 3 years ago
    @Shafi TEXT(B64&H64,"000 0000 0000 0 0")
  • To post as a guest, your comment is unpublished.
    kamlesh manchekar · 3 years ago
    I want to convert digit into words in indian language? How to do that?
  • To post as a guest, your comment is unpublished.
    George · 3 years ago
    @Sami Awad All I get is #name when I do this
  • To post as a guest, your comment is unpublished.
    amrita.d · 3 years ago
    I couldn't covert number into million and billion $ currency. Help me to because I am confused.
  • To post as a guest, your comment is unpublished.
    Amrita · 3 years ago
    I want to convert dollar currency into million or billion format . I am confused do it. could you plz guide me.
  • To post as a guest, your comment is unpublished.
    Shafi · 3 years ago
    Some clarification, when I try to convert below number it changes its format, eg. given below can you explain why this happen? other than zero it works fine

    B64=890151200020,
    H64=0
    J64=TEXT(B64,"000 0000 0000 0 "&H64) it changes to "089 0151 2000 2 0" instead of "890 1512 0002 0 0"
  • To post as a guest, your comment is unpublished.
    Excel Expert · 3 years ago
    @Alexandra Use cell formating. You can get the result as 1-Jan-2017
  • To post as a guest, your comment is unpublished.
    Excel Expert · 3 years ago
    Perfect solution has been found.
    Full formulas could not be written due to space limitation. mail me at mukeshbrahmankar(gmail) for the file. File would be sent on a friendly note, no commercial thing.

    Regards
  • To post as a guest, your comment is unpublished.
    Alexandra · 3 years ago
    Any chace t change date in Text format, not keeping Date format?
    Ex. 1/1/2017 d/m/yyyy in the same way but text formatting?
  • To post as a guest, your comment is unpublished.
    FALSE · 3 years ago
    tnx for your solution
    be healthy
  • To post as a guest, your comment is unpublished.
    John Smith · 3 years ago
    I cannot reproduce your result. When using the TEXT formula trying to convert a number to text, the resulting content was left-aligned but there was no green triangle, meaning the content was still a number, not text. Same result when using the menu command. No triangle.

    I use Excel 2010.
  • To post as a guest, your comment is unpublished.
    John Smith · 3 years ago
    I cannot reproduce your results. When I used the first method trying to convert a number to text, the resulting number was left-aligned but there was not green triangle, meaning the content was still a number, not text. Same result with using the menu command. No green triangle.

    I'm using Excel 2010.
  • To post as a guest, your comment is unpublished.
    Excel Expert · 3 years ago
    @Ajay Ramteke First you need to ascertain that upto how many digits you are going to use as the highest value.
    For Example it is 5 digits.
    In the cell type any 5 digit number for example 59427.
    Now in a different cell convert this into decimal places of 5 digits i.e. 59427/10000 = 0.59427
    Now you can use the function "MID" to break this into 5 different digits i.e. 5, 9, 4, 2, 7
    By using the if formula convert these into words like =IF(A3=5,"Fifty","") and finally use the function "CONCATENATE" to bring these together.
    This is the only way possible.

    If you need I can send you the sample excel sheet.

    Regards
  • To post as a guest, your comment is unpublished.
    Excel Expert · 3 years ago
    @Nischal Ghimire First you need to ascertain that upto how many digits you are going to use as the highest value.
    For Example it is 5 digits.
    In the cell type any 5 digit number for example 59427.
    Now in a different cell convert this into decimal places of 5 digits i.e. 59427/10000 = 0.59427
    Now you can use the function "MID" to break this into 5 different digits i.e. 5, 9, 4, 2, 7
    By using the if formula convert these into words like =IF(A3=5,"Fifty","") and finally use the function "CONCATENATE" to bring these together.
    This is the only way possible.

    If you need I can send you the sample excel sheet.

    Regards
  • To post as a guest, your comment is unpublished.
    Excel Expert · 3 years ago
    @SANCHITA PATRA Use the "IF" function.
  • To post as a guest, your comment is unpublished.
    Excel Expert · 3 years ago
    @Axit Mehta First you need to ascertain that upto how many digits you are going to use as the highest value.
    For Example it is 5 digits.
    In the cell type any 5 digit number for example 59427.
    Now in a different cell convert this into decimal places of 5 digits i.e. 59427/10000 = 0.59427
    Now you can use the function "MID" to break this into 5 different digits i.e. 5, 9, 4, 2, 7
    By using the if formula convert these into words like =IF(A3=5,"Fifty","") and finally use the function "CONCATENATE" to bring these together.
    This is the only way possible.

    If you need I can send you the sample excel sheet.

    Regards
  • To post as a guest, your comment is unpublished.
    Excel Expert · 3 years ago
    @Sherry Lim First you need to ascertain that upto how many digits you are going to use as the highest value.
    For Example it is 5 digits.
    In the cell type any 5 digit number for example 59427.
    Now in a different cell convert this into decimal places of 5 digits i.e. 59427/10000 = 0.59427
    Now you can use the function "MID" to break this into 5 different digits i.e. 5, 9, 4, 2, 7
    By using the if formula convert these into words like =IF(A3=5,"Fifty","") and finally use the function "CONCATENATE" to bring these together.
    This is the only way possible.

    If you need I can send you the sample excel sheet.

    Regards
  • To post as a guest, your comment is unpublished.
    RAMPRAKASH · 3 years ago
    @Ripon [quote name="Ripon"][quote name="SUDIPTA GHOSH"]Hi, I want to convert figure in text, i.e. 102 means one zero two or one hundred two. etc.[/quote]
    I am also want This ans If you get the ans please reply me.[/quote]
    [quote name="Ajay Ramteke"]I would like to convert number to ward text in indian rupees format.
    e.g.-2500
    In Word: Rupees Two Thousand Five Hundred Only.

    If possible please help me.[/quote]
  • To post as a guest, your comment is unpublished.
    Imans · 4 years ago
    [quote name="Rajesh K"]Hi., Using conditional formatting you can do this. Select the range, goto conditional formatting (Cells that contain value), enter the value as per your requirement. Now select format goto Number - Custom and then type the text you are looking for within quotes. You can get your result. It will be useful for visual purpose only. Though the result displayed is in Text format, if you click on the cell it will have original value what it had. Try it....[/quote]

    :lol: horray great it will save time and brain ! thanks
  • To post as a guest, your comment is unpublished.
    Benjamin Jackson · 4 years ago
    Hi there,
    i would like to convert this numner to words in excel
    For example : 12,500.44 to USD twelve thousand five hundred and cents forty four only. Please give excel in add-ins format
  • To post as a guest, your comment is unpublished.
    Benjamin Jackson · 4 years ago
    @Varun Where we can down load. It is possible i need in USD
  • To post as a guest, your comment is unpublished.
    CHOW · 4 years ago
    Hi there,
    i would like to convert this numner to words in excel
    For example : 14,444.44 to FOURTEEN THOUSAND FOUR HUNDRED FORTY FOUR AND CENTS FORTY FOUR ONLY
  • To post as a guest, your comment is unpublished.
    Axit Mehta · 4 years ago
    @indah Same Question Man!

    Axit Mehta
  • To post as a guest, your comment is unpublished.
    Sami Awad · 4 years ago
    You can easily do that, fist lets say that the number is in the cell F44, type this formula in the cell you want to display the number in text :
    =SpellNumber(F44)

    lets say that you have a number in cell c23 , and you wand to display it ni c 24, then you will type in c24 the following: =SpellNumber(C23)