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 5. Total comments: 169

  1. i want this thing in ms-excel
    when i type 225 in a cell than two hundred and twenty five should come in other cell.

  2. thanking you so much for this formulas

  3. Hi all
    i'm creating xls doc using openofficexml epplus
    i adding values in xls using ws.Cells("D1").value = 1234
    i would like to get something like simple quote '1234 as description in "Add an apostrophe to change number to text format" with result 1234 in cell but '1234 in text zone
    any idea ? is it a specific value ? formaula ?
    thx

  4. 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.

  5. 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},"")))

  6. hello madam,

    how to fixed excel sheet in value convert in word .

  7. How to display a numeric value and a string in a excel cell ?

  8. Could you tell me why the excel won't change the number format even if I add an apostrophe in front of them? Is there anything else I should change in the options?

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

  10. I will try this again. I have several spreadsheets that I am converting from Lotus to Excel. The spreadsheets then connect together to make master spreadsheets. I need to be able to explain a number at times, such as labeling it with a name. In Lotus, I was able to just pick a cell next to the cell to be explained and put text in. But in Excel it gives a #value error.

  11. I need to change one cell in a formula to text. How do I get it to ignore the text in the cell.

  12. Thanks for the tip, super helpful!

  13. 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

  14. 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

  15. symbols used to convert numbers to texts

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

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

  18. Dear Sir/ Madam,

    What their is any option to convert multiple column into text by using single method or option.

    regards

    radha krishna

  19. Thank You Sir
    You saved my lot of time.

  20. 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?

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

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

    Please give me suitable answer for above question

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

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

    Please give me suitable answer for above question

  24. numeric to text converting formula

  25. 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.

  26. Excellent.Thank you for the tip.

  27. thanks, it saved my time a lot

    1. Ok

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)