How to convert numbers to text?

[Nagesh]

Cell value of A=500000

Cell Value of B=25000

Cell value of C=A-B.


Now in Cell D, I want the result of C displayed in text format i.e., Four Lakhs Seventy Five Thousand.


How to do this in excel?

 

[Hui]

Have a look at: http://support.microsoft.com/kb/213360

 

[Anar]

The best way to do that is with macros, as Hui suggested.


It is also possible to do that using a combination of Excel functions.


Here is an example,

https://docs.google.com/spreadsheet/ccc?key=0AvS6fHQ9kTRHdDNBWEVqQ2xsbElFSnNFYUVGMkYtMEE&hl=en_US

 

[excelhero]

The best formula I've seen for this is here:


http://www.linkedin.com/groupItem?v...roup_most_popular-0-b-ttl&goback=.gmp_3843467

 

[prasaddn]

hi, You may also refer to http://www.contextures.com/excelfilesRon.html#RF0001, this was link sent by Chandoo on 10/24/2011 Excel Links – After a long time edition..