Pravesh Kumar (Still Learning) (163 Points)
20 January 2010Dear Sir,
anybody knows how to convert any numbers in excel into Indian Rupees in words.
Please reply urgently.
Thanks
Pravesh
PRAVEEN KUMAR
(MBA (Finance) B.Com.(P))
(3443 Points)
Replied 20 January 2010
Dear Pravesh,
Yes i do have a excel sheet that have some macros in it, it is also having the trick you want,
herewith is excel file.
Just save this file in your system,
open the file, enable macros,
you will see a new menu namely "praveen"
just click that you will find 4 macros, 1 is "number to words" just click that, you will get what you want.
Hope this helps, tell me if anyhelp you want from my side.
Thanks
Praveen
CMA Ankur Pandey
(Govt.Job)
(4401 Points)
Replied 23 January 2010
check this excel addin , u have to use formula =num2text(a1) a1 is cell of the amount
if you need any clarification comment me
if you like it thanks me
Abhinay
(FRESHER)
(21 Points)
Replied 10 April 2010
Hai Preveen.This is abhinay from Visakhapatnam.i have seen your file "28_praveen_ke_karamati_macros_updated_.xla" It's working
Please tell me the procedure to prepare that type of files
Saurabh Bisen
(Manager- Finance)
(21 Points)
Replied 17 August 2011
Hey Praveen, Thanks man....its great...
employeesforum
(rkmangal2802@gmail.com)
(146 Points)
Replied 22 September 2011
u can download it from
www.employeesforum.yolasite.com
if want top use it in punjabi language.
shortly i will upload in hindi language also
Exshail
(Software)
(1576 Points)
Replied 23 September 2011
You can download "Rupees in Word" comaddins
from below site.
https://exshail.web.officelive.com/documents/comaddins.htm
BTW here is download link for another related addins.
"Indian Rupees"
https://exshail.web.officelive.com/Addins.aspx
"SpellNoFormula " + "IndianSpellNoFormula " + " IndianSpellNoFormulaHindi "
https://exshail.web.officelive.com/Misc.aspx
"Rupees in Hindi Word Ver. 1.00"
https://exshail.web.officelive.com/ComAddins.aspx
Exshail software
CA. Tanvi Joshi
(Chartered Accountant)
(2729 Points)
Replied 03 November 2011
Please find attached VBA code.. you can copy & paste in VB Module in excel & then use function spellindian to convert number in words.
selva
(Manager IT)
(22 Points)
Replied 01 July 2012
I tried both Praveen's & Tanvi Joshi's. Both worked.
Thanks.
I don't want the Praveen Tab in File menu in all excel files. How to remove Praveen tab from other excel files ?
Exshail
(Software)
(1576 Points)
Replied 02 July 2012
You can also try "Indian Rupees" excel addins from below link.
https://sites.google.com/site/exshail/excel-addins
selva
(Manager IT)
(22 Points)
Replied 04 July 2012
CA Tanvi Joshi's vb code is not working in Office 2007. Please help me
Justin Thomas
(Marketing Head)
(54 Points)
Replied 05 July 2012
Dear Friends,
i am blogger for different topics in MS Excel .Please visit my blog regularly and you can really find cool stuffs over there .....Easy to Difficult topics
https://ourofficeexpert.blogspot.in/
Thank You
Justin Thomas
Sanguina
(None)
(30 Points)
Replied 07 October 2012
I hate using code and i generally use an online tool to convert numbers to words:
https://knowpapa.com/num2words/
This is the Indian Version (talks in Lakhs , crores rather than million billion)
and you can add prefix and suffix like Rupees and 'only' tpo the beginning and end I find it very useful :)
Sowmya K
(Human Resources)
(21 Points)
Replied 07 December 2012
Dear All,
Can someome please help me with entering amount in excel as per Indian Currency Format. Ex: Ten Lakh Rupees, I want it as 10,00,000 in excel
Regards
Sowmya
CAclubindia
