Click here to Skip to main content
Click here to Skip to main content

Convert Currency To Words in Lakh, Crores, etc.

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

Introduction

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.

Background

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.

History

  • 16th February, 2004: Initial post

License

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

Share

About the Author

P.K.Agarwal
Systems Engineer
India India
I love to learn new technology specially IT related. Programming is my hobby.

Comments and Discussions

 
GeneralBugs corrected in the function [modified] PinmemberVidyadhar B.C.14-Oct-07 23:05 
GeneralConvert Currency To Words Solved all problems PinmemberNair Sreekumar31-Jul-07 0:25 
GeneralBug in the code and a workaround Pinmemberkunmun2314-Jul-07 8:53 
GeneralRe: Bug in the code and a workaround [modified] PinmemberVidyadhar B.C.14-Oct-07 18:55 
Questionhow do i use? PinmemberMember #39023758-Mar-07 6:15 
GeneralPls specify the function or the formula to be used in MS Excel/Access [modified] PinmemberSuresh Kardar8-Oct-06 20:13 
GeneralDigit to word conversion program-reg PinmemberS.PRAKASH7-Jul-06 21:17 
GeneralSolved my Problem Pinmembertmistry23-May-06 22:22 
GeneralThousand Digit Not define Properly PinmemberJohn dsoza28-Apr-06 2:57 
GeneralUnable to use the function in access 2003 PinmemberDnyanraj17-Jan-06 0:51 
GeneralWant to use the same for other application Pinmembergotspatel1-Feb-05 4:08 
GeneralProblem in Conversion PinmemberKrishna Kumar Menon30-Aug-04 2:55 
GeneralGreat, but... PinmemberSnyp17-Feb-04 16:45 
GeneralRe: Great, but... PinmemberP.K.Agarwal19-Feb-04 17:06 
GeneralRe: Great, but... PinmemberP.K.Agarwal19-Feb-04 17:10 

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

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

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.141220.1 | Last Updated 17 Feb 2004
Article Copyright 2004 by P.K.Agarwal
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid