Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
How to convert Numbers to text | Excel Worksheet Functions |