Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

# Excel Help

2 replies to this topic

### #1 multiple_2005

multiple_2005

• Members
• 4 posts
• OFFLINE
•
• Local time:06:03 PM

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

jgweed

• Members
• 28,473 posts
• OFFLINE
•
• Gender:Male
• Location:Chicago, Il.
• Local time:06:03 PM

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

tos226

BleepIN--BleepOUT

• Members
• 1,577 posts
• OFFLINE
•
• Gender:Female
• Location:LocalHost
• Local time:07:03 PM

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

Edited by tos226, 04 October 2007 - 12:11 PM.

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users