14,607,796 members

# Convert Currency To Words in Lakh, Crores, etc.

Rate this:
16 Feb 2004CPOL
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

## Share

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

 First Prev Next
 Bugs corrected in the function [modified] Vidyadhar B.C.14-Oct-07 22:05 Vidyadhar B.C. 14-Oct-07 22:05
 Convert Currency To Words Solved all problems Nair Sreekumar30-Jul-07 23:25 Nair Sreekumar 30-Jul-07 23:25
 Bug in the code and a workaround kunmun2314-Jul-07 7:53 kunmun23 14-Jul-07 7:53
 Re: Bug in the code and a workaround [modified] Vidyadhar B.C.14-Oct-07 17:55 Vidyadhar B.C. 14-Oct-07 17:55
 how do i use? pavanghai8-Mar-07 5:15 pavanghai 8-Mar-07 5:15
 Pls specify the function or the formula to be used in MS Excel/Access [modified] Suresh Kardar8-Oct-06 19:13 Suresh Kardar 8-Oct-06 19:13
 Digit to word conversion program-reg S.PRAKASH7-Jul-06 20:17 S.PRAKASH 7-Jul-06 20:17
 Solved my Problem tmistry23-May-06 21:22 tmistry 23-May-06 21:22
 Thousand Digit Not define Properly John dsoza28-Apr-06 1:57 John dsoza 28-Apr-06 1:57
 Unable to use the function in access 2003 Dnyanraj16-Jan-06 23:51 Dnyanraj 16-Jan-06 23:51
 Want to use the same for other application gotspatel1-Feb-05 3:08 gotspatel 1-Feb-05 3:08
 Problem in Conversion Krishna Kumar Menon30-Aug-04 1:55 Krishna Kumar Menon 30-Aug-04 1:55
 Great, but... Snyp17-Feb-04 15:45 Snyp 17-Feb-04 15:45
 Re: Great, but... P.K.Agarwal19-Feb-04 16:06 P.K.Agarwal 19-Feb-04 16:06
 Re: Great, but... P.K.Agarwal19-Feb-04 16:10 P.K.Agarwal 19-Feb-04 16:10
 Last Visit: 14-Aug-20 5:02     Last Update: 14-Aug-20 5:02 Refresh 1