Question about Microsoft Office Standard for PC
How can i comnvert the numerical degits in to text autometically in a specified text. for exeample: Cell A1 contains 100 value and Cell A2 contains 200 value. Now If Cell C1=A1+A2 then the C1 Will show the value 300. Now I want that in Cell D2 the value of C1 will be expressed in Text, i,e, "Rupees Three Hundred Only" --like this. Please help. Raju Saha You can also reply to [email protected]
Raju, There's no easy way to do it as far as I know. What you can do is create a table where in column A you'll have the sum, in this case 300 and in column B you'll have the text i.e. Rupees Three Hundred Only Then you need to use the Vlookup function to retrieve the right text to the number you get.
Posted on Sep 18, 2007
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Jun 06, 2010 | Microsoft Excel for PC
Oct 31, 2008 | Computers & Internet
Jul 21, 2009 | Microsoft Office Excel 2007
May 28, 2009 | Adobe Flash® CS3 Professional Full Version...
Mar 12, 2009 | Microsoft Windows Vista Home Basic for PC
Mar 12, 2009 | Microsoft Office Excel 2003 for PC
Apr 01, 2008 | Microsoft Office Professional 2007 Full...
Dec 09, 2007 | Computers & Internet
Dec 03, 2007 | Microsoft Excel for PC
58 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: