how to spell out number using function in Excel

Check out

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


In article <[email protected]>,
"Beans" <[email protected]> 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" <[email protected]>
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

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" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
"Beans" <[email protected]> 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" <[email protected]>
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

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" <[email protected]> wrote in message
news:[email protected]...
> I'm in need of a function that converts a price amount which will return a
> spelled out text.

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 <[email protected]>,
"Beans" <[email protected]> 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" <[email protected]>
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

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" <[email protected]> wrote in message
news:[email protected]...
> I'm in need of a function that converts a price amount which will return a
> spelled out text.