numeric digit into words

Excel 4635 views 23 replies
i have an excel file called inword whenever we open it automatically installs a macro in excel it shows value in indian format like crore, lacs etc. and not in million, billion. the only drawback with this is when it converts the number in word format it becomes the text format and the formula is not shown. therefore if there is any change in number this function should again be used. if anyone want this utility, pl. send your email address at subhash.agrawal.ca @ gmail.com
Replies (23)
i have an excel file called inword whenever we open it automatically installs a macro in excel it shows value in indian format like crore, lacs etc. and not in million, billion. the only drawback with this is when it converts the number in word format it becomes the text format and the formula is not shown. therefore if there is any change in number this function should again be used. if anyone want this utility, pl. send your email address at subhash.agrawal.ca @ gmail.com

I will be grateful if anyone can mail me utility to convert numbers into word in an excel sheet.

Thanks in advance.

 

There are many tools to convert number to Indian rupees with Addins and also without VBA codes from below site of shailesh.

Excel Addins :Indian Rupees

https://in.geocities.com/shahshaileshs/

Excel Com-Addins : Rupees in Word.

https://in.geocities.com/shahshaileshs/comaddins.htm

 

Excel workbook (no vba codes) : spellnoformula

https://in.geocities.com/shahshaileshs/misc.htm

 

It is very easy to use macros for changing numeric amount into words.

hello everyone .. if anyone requires a software to convert digits into rupees .. can mail me at ...

makhija.varun4 @ ygmail.com

 

Regards,

Varun Makhija

Pcc Student

Originally posted by :VARUN
" hello everyone .. if anyone requires a software to convert digits into rupees .. can mail me at ...

makhija.varun4 @ ygmail.com

 

Regards,

Varun Makhija

Pcc Student
"

 

You can download "Indian Rupees" Addins from

https://in.geocities.com/shahshaileshs/

Shailesh

 

200000

I have downloaded an excel file with modifications for indian rupees you just have to mention the formula for the cell. if g5 = 1234 eg. spellnumber(g5) It will say Rupees One Thousand Two Hundred Thirty Four Only You can modify it to remove Rupees and paise too.
_______________________________________

ffff


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Related Threads
Loading