Which means If the value in A2 is x, then display -40 otherwise display something else. The syntax of this function is: Of course, you can use “EUR” if you want to convert euro amounts. Click OK and Finish and all numbers are now in number format. That's why their format should be unified. I will try this again. word, https://www.technologicaltipstools.online/2016/11/excel-convert-numeric-value-into.html. 1.11205E+15 1112053000152279 123.45 becomes One Hundred Twenty Three Dollars and Forty Five Cents. 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. The TEXT function can apply number formats of any kind, including currency, date, percentage, etc. Just click through steps 1 and 2. https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/. If you are not so formula-oriented, have a look at the part where I explain how to change digits to text format with the help of the standard Excel Format Cells window, by adding an apostrophe and employing the Text to Columns wizard. Congrats!!! Save my name, email, and website in this browser for the next time I comment. Choose "deliminted". I guess it's still due to the cell format but wonder how to fix it by using a formula. 1. I need to replace the numbers, 1-25, with the corresponding industry match. The format_text argument works like a number format, and specifies the formatting that should be used when converting the number to text. Incredible product, even better tech support…AbleBits totally delivers! Ablebits is a fantastic product - easy to use and so efficient. Can somebody help me for following problem ? You may be surprised but the Excel Text to Columns option is quite good at converting numbers to text. 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 I started teaching Excel usage over 25 years ago and have had a career of programming and I can't remember when this issue cropped up. Please tell me what can I do to make it work? please. there is a bug when my amount is "618475" it says "Six Hundred Eighteen Thousand Four Hundred Seventy Five" instead of "six lac eighteen thousand four hundred seventy five". like 2345 = Two thousand Three Hundred and Forty five only. Just follow the steps below to see how it works. [/s]. A VB project dialog box opens. You'll also learn how to troubleshoot, trace errors, and fix problems. As I said in the introduction, you will find the download link at the end of the article. You will see the alignment change to left in the helper column after applying the formula. For me to be able to help you better, please send me a sample table with your data in Excel and include teh result you want to get to support@ablebits.com, how to convert number to word text