HOME HOME
BUDGE BUDGETT-14 14
SALA SALARY RY
ITAX ITAX
ITR-1 ITR-144-15 15
DEDU DEDUCT CTION IONS S
TDS TDS
HOW HOW TO
PAN PAN
SERVI SERVIC CE TAX TAX
CONVERT FIGURES IN TO WORD EXCEL ADD IN INDIAN RUPEE
CHAL CHALLA LAN N
HP
CG
EXCE EXCEL L
TALL TALLY Y
SNAPDEAL GRAND DIWALI SALE BUY NOW
on Monday, June 25, 2012 Custom Search
What we needed was to show a number in the
Indian Rupee format as well a s display the amount
in words. Let me explain. Say we have a figure 12345678. 12345678. If I just use the currency format it will be
SUBSCRIBE FREE EMAIL, JOIN OUR COMMUNITY
displayed as Rs 12,345,678.00. But in India we prefer to use the format Rs. 1,23,45,678.00. That is we use hundreds, thousands, lakhs and crores rather than millions and billions. As far as I k now there is no built in method to display it in the Indian format. (I haven’t tried Office 2007 yet.). Before I dev eloped this Add-In we had to do it manually each time up to 50 times a day. This Add-In saved us a lot of time. The Add-In has 3 functions – INR(), INR(), REVINR() and RSWORDS(). RSWORDS(). The INR() function INR() function converts converts a number to the I ndian Style Comma formatted currency as you can see in the snapshot. The commas are placed in the right places separating lakhs and crores. But the result that
calculations. To you get is in the Text Format. So you cannot directly use the re sult in a formula for calculations. To
POPULAR POSTS
overcome this issue I have a dded another function calledREVINR() calledREVINR().. KNOW YOUR PAN,VERIFY PAN,NAME BY PAN,PAN PA N,PAN CARD STATUS ONLINE
KNOW DEALERS DETAIL BY TIN (VAT) NUMBER OR BY NAME
Relief U/s 89(1) On Gratuity Received In FY 2010-11
The REVINR() function REVINR() function simply converts the result obta ined from using INR function function back to the number format so that you can use it in calculations as demonstrated in snapshot.
Companies Bill 2011- Major Highlights
TDS RATE CHART FY 2014-15 AY 2015-16 TDS DUE DATES
ABATEMENT RA RATE TE IN SERVICES SERVICES TAX AMENDED AMENDE D WEF 01.07.2012 01.07.2012 NT 20 DT 20.06.12
The RSWORDS() function converts converts any number to currency in the form of words. This can be quite
KNOW YOUR PAN NAME VERIFY PAN FREE CHECK NAME BY PA PAN N
useful if you generate your invoices using Excel and you want the amount to be displayed in words. No Change In Repo Reverse Repo Rates SLR Reduced By 0.50 %: Bi-Monthly Monetary Policy Statement, 2014-15 New Categories Of Directors Under Companies Act 2013 2013
Service Tax On Renting Of Immovable Property :Developments And Issues
How to install SureshAddIns? Installing AddIns in Excel is very simple. First you download the AddIn from the link at the bottom of this post and save it on your computer. computer.
BLOG ARCHIVE 2014 (433) (433) ► 2013 2013 (422) (422) ► 2014 (433) (422)
Open Microsoft Excel. Click on Tools> Tools>Add-Ins. Add-Ins. Click on Browse and navigate to wherever you saved the SureshAddIns.xla SureshAddIns.xla and and then click OK. OK. You have installed the AddIn.
▼ 2012 (540) (540) ► December (17) (17) ► November (27) (27)
How to use SureshAddIns? You can use SureshAddIns by SureshAddIns by directly entering the functions functions into a cell like =INR(XX), =REVINR(XX) =REVINR(XX) and =RSWORDS(XX) where where XX is the re ference of the cell you want to convert. Another way is to use the Insert Function Function window which you can open either through the fx button on the toolbar or though the Insert>Function menu. Insert>Function menu. In the category dropdown box choose User
► October (34) (34) ► September (49) (49) Augus gustt (49) (49) ► July July (49) (49) ► Au (49) (43) ▼ June (43)
defined and defined and you will see the above three functions functions of SureshAddIns. SureshAddIns .
(1) ► Jun 29 (1) (1) ► Jun 30 (1)
You are free to use the Add-In as you like. Please do let me know your feedback. Also, if you find any
(2) ► Jun 26 (2) (2) ► Jun 28 (2)
difficulty difficulty in using it do contact me at suresh[at]winsila[dot]com.
(51) ► April (47) (47) ► March (79) (79) ► May (51)
Download SureshAddIn
credit for this post goes to
http://www.dq.winsila.com http://www.dq.winsila.com and for ot her tricks
► February (51) (51) ► January (44) (44)
04/Nov/2014 4:12 PM
visit suresh site http://www.dq.winsila.com
(2) ▼ Jun 25 (2)
Load or unload an Excel add-in program 1. Click the Microsoft Office Button
INCOME TAX RETURN DUE DATE AY 2012-13 INDIVIDUAL F... , and then click Excel Options.
CONVERT FIGURES IN TO WORD EXCEL ADD IN INDIAN RUP...
2. Click the Add-Ins category. 3. In the Manage box, click Excel Add-ins, and then click Go.
(2) ► Jun 22 (1) (1) ► Jun 23 (2)
4. To load an Excel add-in, do the following: 1. In the Add-Ins available box, select the check box next to the add-in that you want to load, and then click OK.
(1) ► Jun 18 (1) (1) ► Jun 19 (1)
2. If the add-in is not currently installed on your computer, click Yes to install it.
► Jun 16 (2) (2) ► Jun 15 (1) (1)
Follow the setup instructions as needed.
TIP
(6) ► Jun 20 (2) (2) ► Jun 21 (6)
(3) ► Jun 13 (1) (1) ► Jun 14 (3)
5. To unload an Excel add-in, do the following: 1. In the Add-Ins available box, clear the check box next to the add-in that you want to unload, and then
(2) ► Jun 09 (2) (2) ► Jun 10 (2)
click OK.
► Jun 08 (3) (3) ► Jun 07 (1) (1)
2. To remove the add-in from the Office Fluent Ribbon, restart Excel. NOTE
Unloading or removing an add-in from the Ribbon does not delete the add-in from your
computer. To delete the add-in from your computer, you must uninstall it.
(2) ► Jun 05 (2) (2) ► Jun 06 (2) (1) ► Jun 03 (1) (1) ► Jun 04 (1)
For Excel 2003 and earlier versions
To install an addin for Excel install addin from Excel's menual Tool->Addin... then browse.
► Jun 02 (1) (1) (462) ► 2010 (407) (407) ► 2009 (127) (127) ► 2011 (462)
Do not change the Place of File after installation.Further If you want to send excel files where this addin has been used then it will not work where addin has not been installed
(90) ► 2007 (53) (53) ► 2008 (90)
588 164
14 Like
118
Recommend
118
427 Follow
Follow
0
60K
��������
����
��� ��� ������ ���� ������ ���
������ ��� ������ ��� ���� ��
������ �
������� ���������� ���� ���������
You might also like HOW TO CREATE A MS EXCEL PIVOT T ABLE – A N INTRODUCTION TDS RATE CHART FY 2014-15 AY 2015-16 TDS DUE DATES COST INFLATION INDEX 2011-12 FINANCIAL YEAR 1981-2012 MICROSOFT EXCEL USEFUL COMMAND GUIDE TIPS SHORT CUTS CONVERT FIGURE TO WORD EXCEL AND EXCEL SHORT CUTS FIVE TIPS FOR PRINTING EXCEL DATA MORE
EFFICIENTLY
SERVICE TAX RATE CHART EXEMPTION LIMIT ,ABATEMENT RATE CHART REVERSE CHARGE CHART E BOOK ON MICROSOFT EXCEL BY CA
SUNIL B GABHAWALLA
EXCEL A DDIN TO C ALCULATE INCOME T AX ,EMI,INTEREST RATE,FD RD M ATURITY AMT AND SPELL FIGURES TO WORDS
SERVICE T AX ON CONSTRUCTION SERVICE WEF 01.07.2010FAQ SERVICE TAX ON CONSTRUCTION SERVICES: CLARIFICATIONS(10.02.2012) Recommended by
04/Nov/2014 4:12 PM
588
164
14
427
2
6
Tumblr
CONVERT FIGURES INTO WORD EXCEL
Excel
excell add in
71 comments: Post Yours!
indian rupee
numbers in to text
Read Comment Policy ▼
PLEASE NOTE: We have Zero Tolerance to Spam. Chessy Comments and Comments with Links will be deleted immediately upon our re view.
Harendra Kumar December 11, 2011 at 2:02 PM
◄1►
Truly it is very useful for excel user in india.Thanks a lo t to Creator. Thanks, Harendra Kumar Pune, India. Reply Replies
Anonymous December 26, 2011 at 4:46 PM
◄2►
Sir, This function is good but one problem is rise i.e. if I add Rs. in figure than other link columns & row found error i.e. they do not calculate total, percantage or etc. Reply Replies
04/Nov/2014 4:12 PM
RAJA BABU December 26, 2011 at 6:32 PM
◄3►
dear HArdbdra, amount in figures and words are normally used in separate cell. so for calculation use amount in figure Reply
Anonymous May 5, 2012 at 11:24 AM
◄4►
great work... thanks a lot....... Keep up.... Reply
Anonymous May 8, 2012 at 1:10 PM
◄5►
thanks it is Truly very useful for excel user in india.Thanks a lot to Creator. India Reply
SATISH May 14, 2012 at 8:21 PM
◄6►
Thanks !
[email protected] Reply
Monoj June 15, 2012 at 4:42 PM
◄7►
I didn't find the download link Reply Replies
Harender June 25, 2012 at 11:19 AM
04/Nov/2014 4:12 PM
thanks a lot...... super like Reply
Anonymous June 25, 2012 at 11:31 AM
◄9►
Dear sir it will not give the result in words if the figures are in negative. please do the same in negative case and give updated version of this. thanks kalpesh shah 9890208175 / 8767131113 kalpeshyshah@rediff mail.com Reply
Anonymous June 26, 2012 at 2:54 PM
◄10►
Sir, Please change Rs. sign to New Indian Rupee symbol when wirting in words Reply
Rajde Rajan June 26, 2012 at 9:49 PM
◄11►
Hey........ friend this is not working in excel 2007.Please give me the function which can convert the currency in INR in excel 2007, pleeeeeese. Reply Replies
C A Tejal June 28, 2012 at 8:11 PM
◄12►
Its a fantastic.... Reply
Anonymous July 14, 2012 at 8:40 PM
04/Nov/2014 4:12 PM
Finally its done.. Thanks for the link, great job! Keep it up Reply
Ankita July 16, 2012 at 11:29 AM
◄14►
Great.......its a very usful thanks a lot Reply Replies
Anonymous July 23, 2 012 at 6:30 PM
◄15►
I am having two properties, one is self occupied, and other is let out. my annual income is below 5 lacs, and interest from saving is also below Rs. 10,000. I have availed home loan on both the houses, and want to claim interest and principal paid. 1) whether I have to file return for f.y. 2011-12 and a.y 2012-13. 2) if yes, which return Itr-1 or itr-2 3) where to claim lo ssess of house property 4) is it in sr. no. 6 of part-B of TI computation of Income of ITR-2. and sch-CYLA by deducting the loss from salary. 5) where to claim principal paid for emi fo r the year. please reply. thanks Reply Replies
04/Nov/2014 4:12 PM
Nitu Komal - NKworld August 3, 2012 at 8:11 PM
Download Free Utility to Convert Excel Number to Word / Text / Rupees. SOURCE http://www.soft.nkworld.in/2011/05/download-ms-excel-hidden-menu-and.html Reply
Anonymous August 6, 2012 at 12:48 PM
◄17►
Hi suresh, i dont want to show the paise thing in the figures ,i just want round of figures how is is possible? Reply Replies
04/Nov/2014 4:12 PM
CA Eldhose September 1, 2012 at 10:28 AM
◄18►
Great Boss. !!!! Reply
Anonymous September 7, 2012 at 7:04 PM
◄19►
Thanks a lot. It is very helpful Reply
Anonymous September 19, 2012 at 2:30 PM
◄20►
THIS HELPS ME TO WRITE NUMBER INTO WORD FORMAT I AM VERY THANK FUL TO YOU Reply
andrews October 1, 2012 at 10:49 AM
◄21►
very nice to see this feature simplified as add ins Thanks a lot...keep post something useful to every one aware of it. Reply
Basheer Ahmed October 2, 2012 at 12:05 PM
◄22►
Thank you Reply
Anonymous October 10, 2012 at 5:08 PM
◄23►
Thanks A Zillion Mr. Suresh - Nikhil Neelakant Reply
Cherry November 3, 2012 at 4:46 PM
◄24►
Working Fine Thanks alot
04/Nov/2014 4:12 PM
Reply
Anonymous November 16, 2012 at 7:25 PM
◄25►
Thank you, it is very useful. Reply
Anonymous November 21, 2012 at 3:59 PM
◄26►
Dear Sir, Is it possible to remove "Rs" from starting so that value can be taken as " 300,000.00" if yes plz let me know at Reply
denis dedhia December 8, 2012 at 3:01 PM
◄27►
Good One Reply
Anonymous December 17, 2012 at 3:19 PM
◄28►
I AM NOT ABLE TO USE..... PLEASE HELP I HAVE EXCEL 2010 Reply
Anonymous December 22, 2 012 at 6:34 PM
◄29►
sir when i transfered this file to another pc where this addin is not installed then this is not running Reply Replies
Manoj Agarwal January 11, 2013 at 4:45 PM
◄30►
Dear Sir, The function to covert courtesy amount (in figures) to legal amount (in wo rds) is indeed good work. However, for formatting of amount in figures as per indian practice of lacks and crores is simply provided in OS itself since Windows 98. Go to Control Panel, Regional & Language Options and there
04/Nov/2014 4:12 PM
customize the numbering formats (under number groupings) which is self explanatory. This is one time step and then no need to covert or re-convert, and it a ff ects display of all the files. Regards, Manoj Agarwal - 9937041788 Reply
Rohit Mishra January 28, 2013 at 3:3 4 PM
◄31►
Dear sir, Please help me i m not sucess this task Rohit Reply
Maruti Londhe February 6, 2013 at 9:32 PM
◄32►
cool................ very very nice Reply
Anonymous February 16, 2013 at 11:18 AM
◄33►
Very good, Kindly give the suggestion to remove Rupees text from wo rds Reply
Anonymous February 25, 2013 at 3:2 8 PM
◄34►
hello all, when i click on the download link http://www.dq.winsila.com/wp-content/uploads/2007/03/SureshAddin.xla it will open a new page with the zunk character. unable to download, please help Reply Replies
Anonymous
04/Nov/2014 4:12 PM
March 2, 2013 at 4:2 2 PM
Hey This is Amazing is this feature also available in MS Word ? what am I supposed to do if I want this to work in MS Word ? Thanks Reply
fine
March 2, 2013 at 10:31 PM
◄36►
Thank you, it is very useful. Reply
Anonymous March 13, 2013 at 9:2 7 PM
◄37►
Thank you ...its great and very useful.. Reply
mann.sachin March 20, 2013 at 1:30 PM
◄38►
Thanks a Lot... It is Very Helpful............... Reply
Dr.RAJENDRAN S . DD CBFD March 21, 2013 at 4:55 PM
◄39►
great work... thanks a lot....... Keep up.... Please prepare Under rupees -------------------------- only ) by enhancing on number. I t will be used to place protective words in preparing bills Reply
Anonymous March 23, 2 013 at 7:13 AM
◄40►
Zillion Thanks .... Reply
Anonymous March 30, 2013 at 1:11 PM
◄41►
Thanks a lot! Reply
04/Nov/2014 4:12 PM
Rahul Tank April 3, 2013 at 9:38 AM
◄42►
very helpfull.....many many thanks....but ask u again same q....remove "Rs" from starting...?? i need only words ....please help Reply
Rahul Tank April 3, 2013 at 10:22 AM
◄43►
very helpfull.....many many thanks....but ask u again same q....remove "Rs" from starting...?? i need only words ....please help Reply
Anonymous April 11, 2013 at 1:47 AM
◄44►
very helpful... thanks a lot... Reply
Hitesh Patel April 20, 2013 at 1:03 PM
◄45►
after instulation,how to use this formula Reply
Ramesh R August 3, 2013 at 11:20 PM
◄46►
Very very usefull and helpfull please keep it Ramesh, Attur Reply
Jitendra Ku. Satapathy September 6, 2013 at 5:02 PM
◄47►
Dear Sir, Its nice and useful function for us. Thanks a lot for this. I also requested you to please add New Symbol for Rs. in that function and also in words some changes like : 50.56 (Rupees Fifty and Paise Fifty Six only) is may kindly be corrected as (Rupees Fifty and Fifty Six Paise only). I also requested you to please give me add-in for date to words function like : 29-12-2013 (Twenty Nine December Two Thousand Thirteen). my Email ID-
[email protected] Frankly I also pay the requisite amount if it not free. Thanking you. J.K. Satapathy Reply
Asha G April 3, 2014 at 2:08 PM
◄48►
Thanks.
04/Nov/2014 4:12 PM
Also we can Try this Excel Add-in - CLICK http://www.xl.nikash.in/2012/06/convert-number-to-english-indian-rupees_8693.html Reply
Raj April 14, 2014 at 12:09 PM
◄49►
Dear Thanks for your add ins this great, work great thanks thanks once again Raj Reply
satish shinde April 20, 2014 at 6:11 PM
◄50►
Thanks sir, very useful and important addins which are provided by you Thanks lot again How we get the new addins or excel creations of your? Reply
Jay April 26, 2014 at 11:06 AM
◄51►
I have added Suresh Add Ins on a file that is shared on a server. It is not a shared work book, just located on a server where more that one computer/user has access to it. However the formula does not seem to work when opened on the shared computers unless I again go in to each location of the equaction rswords() and type it in again. Why is this? Reply
Jay April 26, 2014 at 11:09 AM
◄52►
I am using suresh ad ins for the rswords(). equation. I have it in stalled on a workbook that is saved on a server. However when I access the same work book on another computer that is on the server, the equation dosent work. It shows the path as ='\\Server\logos letterhead\SureshAddin.xla'!RSWORDS(E24). I have to each time then go to that users computer and re enter the equation as rswords() in each cell that it is required to be used in. How to I avoid this problem? Reply
hari mohan aleti May 19, 2014 at 1:30 PM
◄53►
Thanks a lot.Its been lot of help. Hari Mohan Reply
Dinesh Parmar June 14, 2014 at 4:12 PM
◄54►
Thanks, It's vary useful one. Sir, I am using OPENOFFICE, is there such add in for open o ffice too ? If it is please let me know how can I download and install it?
04/Nov/2014 4:12 PM
Once again thanks. Dinesh Parmar Reply
Anubhav August 12, 2014 at 6:53 PM
◄55►
link not work plz do the needful... proveid the link Reply Replies
dharmsoni03 September 13, 2014 at 2:48 PM
◄56►
Thanks dear, it was very useful. Keep it up. Reply
Govinda Raja September 26, 2014 at 9:55 AM
◄57►
Thank you sir. it is very very useful for me and something newly learned Reply
Comment as:
Publish
Disclaimer The contents of this page are solely for informational purpose. It does not constitute professional advice or recommendation of
Income Tax return Fy 2014-15 DUE DATE TO FILE ITR AY 14-15 WHICH ITR FORM YOU SHOULD FILE
04/Nov/2014 4:12 PM
Simple Tax India/Author. Neither the authors nor simple tax India and its affili ates accepts any liabilities for any loss or damage of any kind arising out of any information in this document nor for any actions taken in reliance thereon.
MANDATORY E FILING FY 13-14 DOWNLOAD ITR FORM FY 13-14 PENALTY ON LATE FILING OF ITR HOW TO RESET PASSWORD EFILING SITE 87A RS 2000 ADDITIONAL REBATE
Readers are advised to consult the professional for understanding applicabilit y of this newsletter in the respective scenarios. While due care has been taken in preparing this document, the existence of mistakes and omissions herein is not ruled out. No part of this document should be distributed or copied (except for personal, non-commercial use) without our written permission.
H om e
TD S R at es 13- 14
H RA calcu lat ion
KN OW YO UR PAN
K NOW YO U TI N
P AN APPLI CATION STATU S
K NOW YOU EPF BAL AN CE
Copyright © 2012 Max Mag Theme. Designed by Templateism
04/Nov/2014 4:12 PM
