Convert Number into Indian Rupees in Excel

 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

 thanks alot that works

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

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
 

Hey Praveen, Thanks man....its great...

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

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

Please find attached VBA code.. you can copy & paste in VB Module in excel & then use function spellindian to convert number in words.

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 ?

You can also try  "Indian Rupees" excel addins from below link.
 

https://sites.google.com/site/exshail/excel-addins
 

CA Tanvi Joshi's vb code is not working in Office 2007.  Please help me

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

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)

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