Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
gmet
 
Posts: n/a
Default How do I convert figures to text?

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
  #2   Report Post  
Gary Brown
 
Posts: n/a
Default

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...b;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...b;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


"gmet" wrote:

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

  #3   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Mon, 25 Apr 2005 07:54:06 -0700, "gmet"
wrote:

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
  #4   Report Post  
Andy
 
Posts: n/a
Default

This file might be a help:
http://www.bygsoftware.com/examples/...s/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

"gmet" wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert Excel imported numbers from text to numbers? Alden Excel Discussion (Misc queries) 9 April 1st 05 09:51 PM
How do I convert a number formated as a date to text in Excel? BrotherNov Excel Discussion (Misc queries) 5 March 2nd 05 04:51 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 10:25 PM
How to convert Numbers to text Calif_guy Excel Worksheet Functions 1 November 12th 04 06:12 AM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"