Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Convert numbers into its equivalent in words?(12 to Twelve)
Is there any function that allows me to convert number into their equivelent
in words? Please advise |
#2
|
|||
|
|||
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH RP (remove nothere from the email address if mailing direct) "AAMC" wrote in message ... Is there any function that allows me to convert number into their equivelent in words? Please advise |
#3
|
|||
|
|||
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 - "AAMC" wrote in message ... Is there any function that allows me to convert number into their equivelent in words? Please advise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text to numbers | Excel Worksheet Functions | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Convert text to numbers | Excel Discussion (Misc queries) | |||
How to convert Numbers to text | Excel Worksheet Functions |