Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
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.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel Help


  • Please log in to reply
2 replies to this topic

#1 multiple_2005

multiple_2005

  • Members
  • 4 posts
  • OFFLINE
  •  
  • Local time:05:09 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.

BC AdBot (Login to Remove)

 


#2 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:05:09 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,574 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:06:09 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 :thumbsup:

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





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users