How do I convert figures to text?

[Guest]

I need to produce a template for completing preprinted checks(cheques). How
do I
convert the total figure into text eg. 1,234 - one two three four
Thanks

 

[Guest]

A quick search in Microsoft's Knowledge base turned up -

How to convert a numeric value into English words in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
This article contains sample Microsoft Visual Basic for Applications
functions that you can use to convert a numeric value in a Microsoft Excel
worksheet cell into its equivalent in English words.

and

How To Convert Currency or Numbers into English Words
http://support.microsoft.com/default.aspx?scid=kb;en-us;259663
This article shows you how to create a sample, user-defined function named
ConvertCurrencyToEnglish() to convert a numeric value to an English word
representation. For example, the function returns the following words for the
number 1234.56:
One Thousand Two Hundred Thirty Four Dollars And Fifty Six Cents

HTH,
Gary Brown

 

[Ron Rosenfeld]

I need to produce a template for completing preprinted checks(cheques). How
do I
convert the total figure into text eg. 1,234 - one two three four
Thanks

If you are using this for checks, would you not want to convert to One Thousand
Two Hundred Thirty Four Dollars and Zero Cents? (Or the equivalent if using a
different language)?

If that be the case, then download and install Laurence Longre's morefunc
add-in, (at http://xcell05.free.fr ) and use the NBTEXT function.

Example

D1: 1234

=NBTEXT(D1,,1,"dollar and!","dollars and","cent!","cents",3)

-->One Thousand Two Hundred Thirty-Four Dollars And Zero Cents

Other languages are also supported and it seems to work quite well.


--ron

 

[Andy]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods to convert numbers to words and two cheque writing
routines.

The code is open and commented.

Regards
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy