I want to know about currancy convert function ex. 2200 = Two Thousan Two hundrad
R ROHIT Sep 1, 2006 #1 I want to know about currancy convert function ex. 2200 = Two Thousan Two hundrad
C Carim Sep 1, 2006 #2 Hi, Take a look at Bob's solution http://xldynamic.com/source/xld.xlFAQ0004.html HTH Cheers Carim
A Andy Wiggins Sep 1, 2006 #3 This file might be a help: http://www.bygsoftware.com/examples/zipfiles/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.
This file might be a help: http://www.bygsoftware.com/examples/zipfiles/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.
B bplumhoff Sep 1, 2006 #4 Hello, I suggest to use my function at: http://www.sulprobil.com/html/spellnumber.html HTH, Bernd