how to spell out number using function in Excel

[Guest]

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

 

[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
(e-mail address removed)

 

[JE McGimpsey]

Check out

http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords

 

[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

 

[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.

 

[anaik]

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

 

[Max]

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