LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Converting Numbers from a given cell to English Words (Currency)

Dear All,

I have the SpellNumber macro from the following link,

http://support.microsoft.com/kb/213360

It works fine. But, i want some modifications or alterations in the macro.

I need to use the macro for Indian Rupees. I have tried to edit the macro,
it doesn't work. It is designed for dollars and Cents. But, i want for
Rupees in place of Dollars and Paise in place of Cents.

Ex:

Rs. 1,23,45,678.99

Given Amount can be classified as:

..99 = Ninety Nine Paise
8 = Ones
7 = Tens
6 = Hundreds
5 = Thousands
4 = Ten Thousands
3 = Lakhs
2 = Ten Lakhs
1 = Crore

It should be in the format:

Rupees One Crore Twenty Three Lakhs Forty Five Thousand Six Hundred Seventy
Eight and Ninety Nine Paise Only.

Can you'll help me to get this programming right.

Thanks a lot in advance,

Cheers,

Karan.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CONVERTING CURRENCY TO WORDS SorianoP Excel Discussion (Misc queries) 1 October 9th 08 09:47 PM
HOW TO WRITE NUMBERS IN WORDS(ENGLISH) exel general group Excel Discussion (Misc queries) 4 September 15th 07 05:31 AM
replace numbers in English words- Mani K Excel Worksheet Functions 2 February 12th 07 10:03 AM
convert currency to words or english akishore23 Excel Programming 0 October 31st 05 09:59 AM


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"