B
Beans
I'm in need of a function that converts a price amount which will return a
spelled out text.
spelled out text.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
dominicb
Good morning Beans
There isn't a native Excel function that will do this. I have a fre
add-in available to anyone requesting it that will do this function fo
you, if you would like this, please send me an e-mail.
HTH
DominicB
[email protected]
There isn't a native Excel function that will do this. I have a fre
add-in available to anyone requesting it that will do this function fo
you, if you would like this, please send me an e-mail.
HTH
DominicB
[email protected]
J
JE McGimpsey
R
Ron Rosenfeld
I'm in need of a function that converts a price amount which will return a
spelled out text.
Download Laurent Longre's free morefunc.xll add-in from http://xcell05.free.fr/
and use his NBTEXT function.
--ron
A
Andy Wiggins
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.
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.
A
anaik
can i create a user defined function to spell out number using function in
Excel
Excel
M
Max
Try Bob Phillips' page at:
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://www.xldynamic.com/source/xld.xlFAQ0004.html