Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to convert numeric into words
1) i want 120 to one hundred and twenty only
2) 120.50 to one hundred twenty rupees and fifty paise only these are the 2 quest pls help me |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to convert numeric into words
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "hitesh" wrote in message ... 1) i want 120 to one hundred and twenty only 2) 120.50 to one hundred twenty rupees and fifty paise only these are the 2 quest pls help me |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to convert numeric into words
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 - "hitesh" wrote in message ... 1) i want 120 to one hundred and twenty only 2) 120.50 to one hundred twenty rupees and fifty paise only these are the 2 quest pls help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
how do i convert numbers in figures into words? | Excel Discussion (Misc queries) | |||
How do I convert text answers to numeric | Excel Discussion (Misc queries) | |||
how can I convert numeric number into text | Excel Discussion (Misc queries) |