Click here to Skip to main content
14,607,796 members

Convert Currency To Words in Lakh, Crores, etc.

Rate this:
3.26 (23 votes)
Please Sign up or sign in to vote.
3.26 (23 votes)
16 Feb 2004CPOL
Convert a given currency in words with Indian style digital grouping


In the computing world, the convention used for grouping of digits is based on international standards which generally follows American practice. It means that digits are grouped in groups of two digits each, i.e. thousands, millions, billions, etc. However, people in India are habituated to groups of three, two, two... This groups form the thousands, lakhs, crores, etc. To solve this problem, a function has already been posted on CodeProject by me for converting any number to the groupings of thousands, lakhs, crores, etc. In continuation of this, the function here converts any number to the number in words with digit grouping of thousands, lakhs, crores, etc.


This function is in Visual Basic and is based on the knowledge base article of Microsoft. The original article converts the number to the international digit grouping, i.e. thousands, millions, billions, etc.

Using the Code

As the function is written in Visual Basic, the same may be used in any application using Visual Basic as the scripting language. For using the code in Excel, Word, Access, simply copy and paste the full code in the Visual Basic module and use the function.

How It Works

The function is named as NumberToWords. This accepts a parameter of type variant. First, the function checks the existence of decimal in the number passed as parameter. If decimal exists, it constructs the word for paisa. After removing the decimal digits from the number, it converts digits, tens and hundreds by using routine ConvertDigits, ConvertTens and ConvertHundreds respectively. It constructs and returns a string containing the number in words with rupees and paisa as prefix and suffix.


  • 16th February, 2004: Initial post


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Systems Engineer
India India
This member doesn't quite have enough reputation to be able to display their biography and homepage.

Comments and Discussions

GeneralBugs corrected in the function [modified] Pin
Vidyadhar B.C.14-Oct-07 22:05
MemberVidyadhar B.C.14-Oct-07 22:05 
GeneralConvert Currency To Words Solved all problems Pin
Nair Sreekumar30-Jul-07 23:25
MemberNair Sreekumar30-Jul-07 23:25 
GeneralBug in the code and a workaround Pin
kunmun2314-Jul-07 7:53
Memberkunmun2314-Jul-07 7:53 
GeneralRe: Bug in the code and a workaround [modified] Pin
Vidyadhar B.C.14-Oct-07 17:55
MemberVidyadhar B.C.14-Oct-07 17:55 
Questionhow do i use? Pin
pavanghai8-Mar-07 5:15
Memberpavanghai8-Mar-07 5:15 
GeneralPls specify the function or the formula to be used in MS Excel/Access [modified] Pin
Suresh Kardar8-Oct-06 19:13
MemberSuresh Kardar8-Oct-06 19:13 
GeneralDigit to word conversion program-reg Pin
S.PRAKASH7-Jul-06 20:17
MemberS.PRAKASH7-Jul-06 20:17 
GeneralSolved my Problem Pin
tmistry23-May-06 21:22
Membertmistry23-May-06 21:22 
GeneralThousand Digit Not define Properly Pin
John dsoza28-Apr-06 1:57
MemberJohn dsoza28-Apr-06 1:57 
GeneralUnable to use the function in access 2003 Pin
Dnyanraj16-Jan-06 23:51
MemberDnyanraj16-Jan-06 23:51 
GeneralWant to use the same for other application Pin
gotspatel1-Feb-05 3:08
Membergotspatel1-Feb-05 3:08 
GeneralProblem in Conversion Pin
Krishna Kumar Menon30-Aug-04 1:55
MemberKrishna Kumar Menon30-Aug-04 1:55 
GeneralGreat, but... Pin
Snyp17-Feb-04 15:45
MemberSnyp17-Feb-04 15:45 
GeneralRe: Great, but... Pin
P.K.Agarwal19-Feb-04 16:06
MemberP.K.Agarwal19-Feb-04 16:06 
GeneralRe: Great, but... Pin
P.K.Agarwal19-Feb-04 16:10
MemberP.K.Agarwal19-Feb-04 16:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Posted 16 Feb 2004


24 bookmarked