Is it possible to convert numbers into words in a cell by using MS Excel formula or function? How?

Yes, it is,,We can do by using the formula VB or macros, or by using the main functions of the IF and VLOOKUP.

Yah, it is possible to convert numbers into words in a particular cell using MS Excel formula

Yes.. You may use "Spellnum function" but you need to insert a module in the specific sheet or workbook. This might help you. https://support.microsoft.com/en-us/kb/213360

Yes. It is possible to do so especially when you are working on a combination worksheet and need to tabulate financials with accruals and returns.

 

Yes, by using VB and Modue

Yes, first determine the second column currency number format Third, go to the Data menu and clicking on the text columns and choose Fourth end and Excel will change the numbers

Please check this

https://support.microsoft.com/en-us/kb/213360

Regards

Yes it is, we can by  "Spellnum function" , we need to insert a module in the specific sheet or workbook.

YES. 

1. Select the cell that you want.
2. Click Insert Function on the Standard toolbar.
3. Under Or select a category, click User Defined.
4. In the Select a function list, click SpellNumber, and then click OK.
5. Enter the number or cell reference that you want, and then click OK.

Yes, using TEXT funtion. Its syntax is

=TEXT(Value, Format)

 

Value can be constant or cell reference

 

Example 

1. =TEXT(345, "0") 

returns 345. cell format will be text. You can see it left aligned. Numbers are Right aligned.

 

Alternative way without using function

Select the cell(s) containing number(s) , Right-Click to access short cut menu, Select Format Cells, From the Category list select Text , Click OK button