Comments on: How to convert numbers to text using Excel TEXT function and other options

This tutorial shows how to convert number to text in Excel 2016 - 2010. See how to accomplish the task with the Excel TEXT function and use number to string to specify the formatting. Learn how to change number format to text with the Format Cells… and Text to Columns options. Continue reading →

Comments page 2. Total comments: 106

  1. The Text to Columns method works. Thanks!
    The Format Cell to Text is not working any more; The number remains in a number format. Either a bug or a "bug by design".

    1. Yup, same experience. Kinda annoying that Format Cell to Text doesn't work

  2. Good day

    Is it possible to convert such a delimited text of 00000304838 to be 3,048.38 in excel.

    Thank you

      1. Thank you very much, stay blessed.

  3. I was looking for a way to convert numbers into letters. So 1,2,3,4,5*,6 becomes A,B,C,D,E*,F (* is not multiply but a symbol of any type)

    A bunch of numbers in one text box would become letters in another.

  4. How to convert 92300640317 in word

  5. Hi
    How Can change dd mmm format to dd-mm-yy.

      1. Hi
        I am currently working with international NGO in Afghanistan, and I wanted to excel to convert number in to text in the other cell, despite I have tried several times and followed different directions in result I would not be able to successfully overcome?

  6. How to convert num counting to alphabetic counting?

    1. 1. Select numbers, you want to sort.
      2. From Data ribbon select Text to columns.
      3. Click twice Next button.
      4. On Column data format select Text and click Finish.
      5. Now you can sort Numbers as Text.

  7. hi can you please help ma that how can i change 11/1/1950 into 11-50

    1. For e.g.: in cell A1 - 11/1/1950
      =TEXT(A1,"dd-yy")
      Ans: 11-50

  8. The last way: "Convert numbers to text in Excel with Text to Columns wizard" -- is the best!!!
    Additionally, it can work in reverse and in other ways!!! Superb!!!
    Congrats!!! & Thx a lot!!! Artur

    1. Best solution for this problem!!! AWESOME. Thank you!

    2. Thank you very much for your feedback, Artur! Glad to hear you enjoy using our add-in :)

  9. How would you make a spreadsheet read a letter to a number as in if I type in just the letter x in a cell it would automatically change it to -40?

    1. Tibor:
      You would use an IF THEN statement which would look like this:
      =IF(A2="X",-40,"Something Else")
      Which means If the value in A2 is x, then display -40 otherwise display something else.
      The details on how these statements work and examples can be found here on AbleBits.

      1. Thank you Doug,

        I see what you are saying but how can I convert any cell in column A to equal -40 when typing in x? What you described does change it but only for that one cell where the formula is entered

        1. Tibor:
          You can copy the formula down the column. The A2 address will change automatically as you copy it down the column.
          Highlight the cell then click and grab the little black box in the lower right-hand corner of the cell and drag it down the column.

  10. I'm trying to link a cell that has a name in it to another sheet. The cell is actually words, not numbers, but I get either the formula or the number zero as if the cell is reading a formula instead of the words.

    I've tried your solutions to convert numbers to text and it did not give me the name, only 0 or the formula.

    Can you help?

    1. first select the cell where you want to get the copied name type = and traverse to the sheet where the name is already present, click on that cell and press ENTER. drag the cell to get other names

  11. is it possible to use a formula or conditional formatting to convert a number value into a text string. For example: I have a series of tasks assigned numbers 1 - 5. I'd like to have a text value display in the next column that if A1=1 then B1 would contain the text "submitted" and if A2 = 2 then B2 would contain the text "in progress", A3= 3, B2=support ticket issued... is this possible?

    1. Hi,

      from what you described, I believe you may find the IF function useful. Please take a look at this article to learn how you can apply it to your table.
      Hope this helps!

  12. can any body guide me how to fix the specific code for tex/name in excel sheet on typing the name we see the result of specified code in required column.

    for example when i type "apple" and its code (100) appear in the required cell.

  13. hi
    How find the length of string For example in cell A1 Dilip sai001 is there so i want count for alphabets only ,if we use Len () means it will count space and numbers also So can u help me

    1. Hi Dilip,

      You should use the following formula:
      =SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9,0},"")))

  14. how to convert number to word text
    like 2345 = Two thousand Three Hundred and Forty five only. in rupees

  15. I have a text '00123015004471215225' and would like to convert it to number, but after convert it using TEXT function or 'CONVERT TO NUMBER' cell option it convert it to number '123015004471215000' which is not correct. Please suggest.

    1. Hello, Mayur,

      Sorry, looks like there is no easy way to achieve this. I'm afraid we cannot help you with this task.

      1. √ Numeric value will show if √ is shown in besides column

  16. Can somebody help me for following problem ?

    I want to convert number to text in excel.

    For example if I have 1000 in Cell A1, I need it in text in Cell A2 as Rupees One Thousand only.

    Please help

  17. how to convert number to word text
    like 2345 = Two thousand Three Hundred and Forty five only.

  18. how to convert number to word text
    like 2345 = Two thousand Three Hundred and Forty five only

  19. Sir Pleas find ,
    2053.00/=(TWO THOUSAND FIFTY THREE ) ON FORMULA EXCEL SHEET

    1. Please advise what is the correct function to use to convert number value to text

        1. hello
          this is in that format(000-000-000.00)
          i want (00 00 00 000.00) in the format

        2. Your solution is not working when I closed excel than opening it again. How to set up still processing without opened not working?

  20. 3256..........I want to "Thirty two hundred fifty six"
    Please give me suitable answer for above question

  21. 225........."Two hundred twenty five"

    Please give me suitable answer for above question

  22. sir i want currency in text format for Exm:

    "225........."Two hundred twenty five"

    Please give me suitable answer for above question

  23. numeric to text converting formula

  24. The "Text to Columns" method is exactly what we needed. It works better than the Format Cells option because with numbers having lots of digits, Excel put them into Scientific Notation when formatting as text, and that was not at all what we wanted. And this method is simpler than using the Helper column. Thank you.

  25. Excellent.Thank you for the tip.

  26. thanks, it saved my time a lot

    1. Ok

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)