Register now or log in to join your professional community.
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. 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.
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