I'm in need of a function that converts a price amount which will return a
spelled out text.

Check out

http://www.mvps.org/dmcritchie/excel...numberstowords


In article ,
"Beans" wrote:

I'm in need of a function that converts a price amount which will return a
spelled out text.

On Fri, 26 Aug 2005 23:49:02 -0700, "Beans"
wrote:

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

Good morning Beans

There isn't a native Excel function that will do this. I have a free
add-in available to anyone requesting it that will do this function for
you, if you would like this, please send me an e-mail.

HTH

DominicB



--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=399697

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
-

"Beans" wrote in message
...
I'm in need of a function that converts a price amount which will return a
spelled out text.

can i create a user defined function to spell out number using function in
Excel

Try Bob Phillips' page at:
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"anaik" wrote in message
. ..
can i create a user defined function to spell out number using function in
Excel