Excel Help

Excel Help CONVERSION OF FIGURES INTO WORDS

#1 multiple_2005

New Member

Group: Members
Posts: 4
Joined: 20-June 05

Posted 04 October 2007 - 03:40 AM

Excel question : converting figures into words...
In my EXCEL sheet , If I have amount in figures in one cell, how can I automatically convert the amount in figures into words in another cell beside it.
If you can suggest any formula, function or any other method in EXCEL , I shall be higky obliged as I thousands of records in my EXCEL workbook wherein i have to convert all the figures into words.

#2 jgweed

Forum Addict

Group: Global Moderator
Posts: 27,600
Joined: 11-April 04
Gender:Male
Location:Chicago, Il.

Posted 04 October 2007 - 09:26 AM

What is the relationship between the figures and the words?
How many figures (and words) are we talking about---1-10 would be different than 1-20,000.
Cheers,
John

Whereof one cannot speak, thereof one should be silent.

#3 tos226

BleepIN--BleepOUT

Group: Members
Posts: 1,423
Joined: 21-October 04
Gender:Female
Location:LocalHost

Posted 04 October 2007 - 12:07 PM

To date, as far as I know there is no simple function. The solution is to build your own function in Visual Basic which is part of Excel, and then use that function in a standard way, as if it were built-in, by picking it from the user defined functions group on the function selection menu. This good link explains how.
http://support.microsoft.com/kb/213360

Now, if it's something as simple as the 1-10 example, a lookup table, or a bunch of nested IFs would do the job: =IF(A1=1,"one",IF(A1="2","two", ... , IF(A1="10","ten","Not translated")))))))))) <-- 10 close parenthesis for every one opened :thumbsup: