Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
spellnumber formula in ms excel
How to convert dollars in words (Exp. $100 to convert into One Hundred Dollars)
With regards, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
spellnumber formula in ms excel
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) " wrote in message ... How to convert dollars in words (Exp. $100 to convert into One Hundred Dollars) With regards, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
spellnumber formula in ms excel
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 dollars in words (Exp. $100 to convert into One Hundred Dollars) With regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |