Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
cover #s to text
How to convert #s to text. (for check printing)
Example: 5,136.25 covert to "Five Thousand, One Hundred, Thirty-six and 25/100" etc Thanks for the help |
#2
|
|||
|
|||
Take a look at
http://xldynamic.com/source/xld.xlFAQ0004.html wrote in message ... How to convert #s to text. (for check printing) Example: 5,136.25 covert to "Five Thousand, One Hundred, Thirty-six and 25/100" etc Thanks for the help |
#3
|
|||
|
|||
See
http://support.microsoft.com/default...b;en-us;213360 Regards Rowan " wrote: How to convert #s to text. (for check printing) Example: 5,136.25 covert to "Five Thousand, One Hundred, Thirty-six and 25/100" etc Thanks for the help |
#4
|
|||
|
|||
Want to correct your clock?
-- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... How to convert #s to text. (for check printing) Example: 5,136.25 covert to "Five Thousand, One Hundred, Thirty-six and 25/100" etc Thanks for the help |
#5
|
|||
|
|||
your date is wrong. if on purpose to stay at the top of the list - BAD. If
inadvertent, still there. many will just delete. -- Don Guillett SalesAid Software wrote in message ... How to convert #s to text. (for check printing) Example: 5,136.25 covert to "Five Thousand, One Hundred, Thirty-six and 25/100" etc Thanks for the help |
#6
|
|||
|
|||
FINALLY, he is in the correct place!
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Don Guillett" wrote in message ... your date is wrong. if on purpose to stay at the top of the list - BAD. If inadvertent, still there. many will just delete. -- Don Guillett SalesAid Software wrote in message ... How to convert #s to text. (for check printing) Example: 5,136.25 covert to "Five Thousand, One Hundred, Thirty-six and 25/100" etc Thanks for the help |
#7
|
|||
|
|||
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 the "SPELLNUMBER" function, which can be used in your spreadsheets, two methods to convert numbers to words and two cheque writing routines. The code is open and commented. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - wrote in message ... How to convert #s to text. (for check printing) Example: 5,136.25 covert to "Five Thousand, One Hundred, Thirty-six and 25/100" etc Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |